Here is the command
directory=DATAPUMP_DIR dumpfile=user_date.dmp logfile=user_date.logexpdp user/password@sid schemas=schema_name include=TABLE:"IN ('TABLE1', 'TABLE2')"
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