This content has been marked as final. Show 3 replies
if you set audit_trail=none you can startup the database even if AUD$ does not exist, then please immediately
create the table SYS.AUD$ again, use dbms_metadata.get_ddl to first extract the DDL of AUD$ for your version,
Harm ten Napel
this sounds good. I will test this next time and think this will help us much
To archive your aud$ table (which locates another tablespace) : http://ulfet.blogspot.com/2013/02/archive-and-purge-aud-table.html
Also you can DBMS_AUDIT_MGMT.SET_AUDIT_TRAIL_LOCATION for moving standart aud$ table`s to another tablespace then disable audit of database and (make tablespace read only which new migrated tablespace) then using skip read only tablespace command via rman you can duplicate your production database.
to move aud$ table`s tablespace to aother tablespace please refer to : http://ulfet.blogspot.com/2012/12/oracle-audit-fine-grained-audit.html