EXPDP-- Export Dump

Hi,

Lets see some basic steps to do Export data from one  schema another schema.

To do export data ,we have Oracle Utility i.e. EXPDP and same way to do import in another schema ,we can use IMPDP .

Dump file which  is created by EXPDP can be imported by using only IMPDP utility.


Basic Requirements:
1) Need to have directory ==> When we do EXPDP then need to specify directory name.In this directory only DUMP file will be stored and can be used further to do import.


Check  here to create directory.


2) Privilege ==>  Need to get Privilege from DBA to do Export/Import in any schema.

Those are..

SQL> grant EXP_FULL_DATABASE to CNYCBAIND;

Grant succeeded


SQL> grant IMP_FULL_DATABASE to CNYCBAIND;

Grant succeeded.


You can query below table to check whether your schema got privilege or not.

select * from dba_role_privs where grantee='SCOTT';

here 'SCOTT' is schema name,replace this with your schema name.

Now  you are ready to do export or import.

1) How to do Full export.

By default ,oracle Expdp will do full database export.

username ==> need to specify your schema credentials
Directory==> Directory name which you created in 1st step
Dumpfile==> Specify name whichever you want.Dumpfile will be  created with same name which you mentioned here.
Logfile ==> Specify name whichever you want.Log file is to check your Export or import activity status and errors etc.
Parallel ==> How many process to run parallel for your export or import activity.

Please note, mention all options names in  CAPS only.

expdp USERNAME=Username/Password DIRECTORY=CBADUMP
DUMPFILE=expdp_full.dmp
LOGFILE=Export_Full.LOG
PARALLEL=8



2) How to do particular table export.

expdp USERNAME=Username/Password DIRECTORY=CBADUMP
DUMPFILE=expdp_table.dmp
LOGFILE=Export_table.LOG
PARALLEL=8
TABLES=ICTB_ENTRIES_HISTORY

TABLES-->  Specify which table you want to export,suppose if you want to export multiple tables then use ','(comma) between tablenames.