Skip to content

Datapump command exclude table

Datapump Command exclude table :

expdp system/Admin123 directory=exp_dir dumpfile=exp_dump.dmp logfile=exp_dump.log schemas=scott exclude=TABLE:\”IN \(\’EMP\’\)\”

 

For two table exclude

expdp system/Admin123 directory=exp_dir dumpfile=exp_dump.dmp logfile=exp_dump.log schemas=scott exclude=TABLE:\”IN \(\’EMP\’,\’DEPT\’\)\”

No comments yet

Leave a comment