Export Data Pump Utility (expdp)

Following sample shows you how to export tables using data pump utility in Oracle 10g. Similarly you can export tablespace or full database.

SQL> grant create any directory to scott;

Grant succeeded.

SQL> conn scott/tiger@sample

Connected.

SQL> create directory dump_dir as 'E:\ORACLE\PRODUCT\10.2.0\ADMIN\SAMPLE\DPDUMP';

Directory created.

SQL> grant read,write on directory dump_dir to public;

Grant succeeded

SQL> select * from dba_directories;

Now, use the command expdp to use the Data Pump utility. The following screen shot will help you with the command.

Monitoring progress of Data Pump job:

SELECT owner_name,job_name, operation, job_mode, state

FROM dba_datapump_jobs;