Parfile name export.par
userid=system/password
SCHEMAS=UAT_2016_XXX
DIRECTORY=FULL_BACKUPS
DUMPFILE=UAT_2016_XXX_%U.dmp
LOGFILE=UAT_2016_XXX.log
INCLUDE=TABLE:"IN('AAA','BBB','CCC','DDD','EEE','FFF')"
Command
expdp parfile=export.par
To see more options
expdp help=y
userid=system/password
SCHEMAS=UAT_2016_XXX
DIRECTORY=FULL_BACKUPS
DUMPFILE=UAT_2016_XXX_%U.dmp
LOGFILE=UAT_2016_XXX.log
INCLUDE=TABLE:"IN('AAA','BBB','CCC','DDD','EEE','FFF')"
COMPRESSION=ALL
PARALLEL=8Command
expdp parfile=export.par
To see more options
expdp help=y
No comments:
Post a Comment