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