Tuesday, December 8, 2015

Export tables with the expdp command and a parfile

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')"
COMPRESSION=ALL
PARALLEL=8

Command
expdp parfile=export.par

To see more options
expdp help=y


No comments: