Friday, March 30, 2012

Exclude specific tables from expdp

Here is the command
 
expdp user/password@sid schemas=schema_name include=TABLE:"IN ('TABLE1', 'TABLE2')" 
directory=DATAPUMP_DIR dumpfile=user_date.dmp logfile=user_date.log
 
Some operating systems need special characters to be escaped
 
include=TABLE:\"IN (\'TABLE1\', \'TABLE2\')"
 
Or
 
include=TABLE:\"IN \(\'TABLE1\', \'TABLE2\'\)"
  
 
 
 
 

No comments:

Post a Comment