Describe désert/workarea/gzyc here.

== expdp ==

一、創建導出數據存放目錄

如：mkdir /oracle/tmp

二、創建directory邏輯目錄

CREATE OR REPLACE DIRECTORY DUMP_DIR AS '/oracle/tmp';

GRANT read, write ON DIRECTORY dump_dir to USER;

{{{
expdp scott/scott schemas=scott logfile=expdp.log dumpfile=expdp_%U.dmp DIRECTORY=DUMP_DIR METRICS=Y parallel=8;
}}}

== impdp ==
mkdir /oracle/tmp


CREATE OR REPLACE DIRECTORY DUMP_DIR AS '/oracle/tmp';

#GRANT read, write ON DIRECTORY dump_dir to USER;

{{{
impdp system version=11.2.0.4 tables=tab1 metrics=y 
impdp \"system as sysdba\" schemas=r1 directory=dump_dir dumpfile=expdp_r1*.dmp logfile=impdp_r1.log version=11.2.0.4 metrics=y
}}}