Data Pump kullanımına örnek

EXPORT:

SQL> CREATE OR REPLACE DIRECTORY test_dir AS '/oracle/oradata/';
SQL> GRANT READ, WRITE ON DIRECTORY test_dir TO system;

$ expdp system/oracle full=y directory=test_dir parallel=4 dumpfile=test%U.dmp logfile=exp01.log

yada

$ nohup expdp system/oracle full=y directory=test_dir parallel=4 dumpfile=test%U.dmp logfile=exp01.log &

yada

$ expdp system/oracle schemas=SCOTT directory=test_dir parallel=2 dumpfile=test%U.dmp logfile=exp01.log

yada

$ expdp system/oracle tables=emp,dept directory=test_dir parallel=2 dumpfile=test%U.dmp logfile=exp01.log

IMPORT:

Daha önce oluşturulmadı ise:

SQL> CREATE OR REPLACE DIRECTORY test_dir AS '/oracle/oradata/';
SQL> GRANT READ, WRITE ON DIRECTORY test_dir TO system;

$ impdp system/oracle123 schemas=XXX directory=test_dir parallel=4 cluster=n dumpfile=test%U.dmp logfile=imp01.log