Differences between revisions 2 and 3
⇤ ← Revision 2 as of 2020-09-04 06:22:23 →
Size: 427
Editor: 14
Comment:
← Revision 3 as of 2020-09-04 06:33:45 → ⇥
Size: 395
Editor: 14
Comment:
Deletions are marked like this. Additions are marked like this.
Line 16: Line 16:
expdp scott/scott schemas=scott logfile=expdp.log dumpfile=expdp_%U.dmp DIRECTORY=DUMP_DIR CONSISTENT=Y EXCLUDE=STATISTICS METRICS=Y parallel=8; expdp scott/scott schemas=scott logfile=expdp.log dumpfile=expdp_%U.dmp DIRECTORY=DUMP_DIR METRICS=Y parallel=8;

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 METRICS=Y parallel=8;

désert/workarea/gzyc (last edited 2020-09-04 08:52:05 by 14)