expdp

Oracle expdp 수행시 참고 (대표적인 옵션)

-. 작업 상황에 따라서 옵션 변경

 

create directory exp_dump as '/export';
 
expdp \'/as sysdba\' directory=exp_dump parfile=exp_full.par
 
-- exp_test.par 
dumpfile = exp_test.dmp
logfile  = exp_test.dmp.log
schemas  = [schema]
tables   = [schema].[table_name]
exclude  = table_statistics, index_statistics
query    = "where DAY < '20210101'"
parallel = 16
cluster  = n
full     = y