I just have one question regarding the table SYS.AUD$.
Here is the Szenario we have:
We just move the table AUD$ into a special tablespace and activate default Auditing on Production Databases.
Now we clone our databases with rman duplicate database to Test environments.
Customers does not want to duplicate the GB's of Auditing as well, so we think about to exclude the AUDITING Tablespace from cloning.
But we guess its not possible to start DB without AUD$ table.
How can we proceed to *"create" the table in e.g AUDITING Tablespace* with maybe 100M size that Oracle will accept this table and work normally if the audit_trail is set to NONE in pfile/spfile of TEST Environment.
Is there any function to recreate the table aud$ (as I have seen in 10g to create table) ?
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,
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