EXP & IMP Excersise

Here we ll see some examples about Export and Import .exp and imp are the executables that allow to make exports and imports of data objects (such as tables). With the exp and imp we used to take backup of data structures and data from where logical backups can be made.Its a light weight backup process.

Before taking the export first check below :

1.Select count(1) from dba_objects where owner='&OWNERNAME';

2.select object_type,object_name from dba_objects where owner=upper('&OWNERNAME');

3.select the users credential if the necessary priveleges are there to export and impot
EXP_FULL_DATABASE
IMP_FULL_DATABASE


4.Go to the Source Directory where you will put the export dump

EXP example:
C:\orcl\myExportDump>exp system/budhiya buffer=200000 file=export_scott.dmp compress=n owner=SCOTT log=scott.log

IMP example:
C:\orcl\myExportDump>imp system/budhiya buffer=200000 commit=y file=export_scott.dmp ignore=y fromuser=SCOTT touser=RAMA log=imp.log rows=y grants=Y INDEXES=y

EXP& IMP only tables example
C:\orcl\myExportDump>exp system/budhiya tables=dip.food file=export_scott.dmp compress=n

C:\orcl\myExportDump>imp system/budhiya buffer=200000 commit=y file=export_scott.dmp ignore=y fromuser=RAMA touser=DIP log=imp.log rows=y grants=Y INDEXES=y


For more info refer :
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96652/ch01.htm#1006128