Describe désert/workarea/gzyc here.

expdp

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

如：mkdir /oracle/dump

二、創建directory邏輯目錄

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

GRANT read, write ON DIRECTORY dump_dir to USER; 

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