Tuesday, February 27, 2018

expdp exclude table example

Syntax is handy for expdp exclude tables list


expdp system directory=DBA_DP dumpfile=xOLLER_27Feb.dmp logfile=xOLLER_27Feb.log schemas=xOLLER  exclude=TABLE:\""IN \(\'xOPACKET\',\'xOPCKTDATA\',\'ExxCKTHIST\',\'EOCxxIPKT\',\'EOCxxPKTDATA\',\'EOOUTGxxxFREDREPORT\',\'EOFRExxxTDATA\',\'EOFxxCLIPKT\')\""