Wednesday, 3 September 2025

How to Exclude AUDIT TRAILS tables in FULL Database Export

 


Correct way to exclude Audit trail tables like SYS.AUD$ during a full database export is to use EXCLUDE=AUDIT_TRAIL/AUDIT parameters. expdp system/pwd directory=exp dumpfile=Full.dmp logfile=full.loglog full=y rows=n EXCLUDE=AUDIT_TRAILS OR expdp system/pwd directory=exp dumpfile=Full.dmp logfile=full.loglog full=y rows=n EXCLUDE=AUDIT

No comments:

Post a Comment