Data Pump Notes

Oracle data pump documentation:
Following points may be noted for data pump
1) Not supportive with the normal exp & imp
2) Self tuning: Parameters like Buffer are not required or needed.
3) Parallelism: Access data through multiple path
4) Runs on the server side rather than on client side
Directory Object:
This is the object through which oracle creates dumps and log files.
To perform datapump operation:
1) Create directory object:
SQL> create directory datapump as ‘c:\datapump’
Here a directory is created with the name datapump in c folder. This directory is where the logs and the dump files will be stored. This directory will be used as a parameter for performing datapump export or import operation.
One thing to note here is that the log files with the same names in the directory will get overwritten and the dump file with the same name will result in error.
2) Give Access:
SQL>give exp_full_database to user;
SQL>grant read, write on directory datapump to user;

3) Export Command:
expdp username/pwd FULL=y DIRECTORY=datapump DUMPFILE=expdata.dmp LOGFILE=expdata.log