To Exclude a Schema/Schemas from EXPORT Job
expdp system/oracle FULL=Y DUMPFILE=test2.exp EXCLUDE=SCHEMA:"in\('SCOTT'\)"
expdp system/oracle FULL=Y DUMPFILE=test2.exp EXCLUDE=SCHEMA:\"IN \(\'WMSYS\', \'OUTLN\'\)\"
expdp system/oracle FULL=Y DUMPFILE=test2.exp exclude=schema:\"IN \(SELECT username FROM all_users where username in('SCOTT','HR')\)\"
To Exclude a Table/Tables from EXPORT Job
expdp system/oracle FULL=Y DUMPFILE=test2.exp EXCLUDE=TABLE:"in\('EMPLOYEE'\)"
expdp system/oracle FULL=Y DUMPFILE=test2.exp EXCLUDE=TABLE:\"IN \(\'EMPLOYEE\', \'DEPARTMENT\'\)\"
No comments:
Post a Comment