Re: SYS.AUD$ ran out of space

Kurt,  

You may want to think about moving the sys.aud$ table out the system tablespace so that you can enlarge its size to fit the type of auditing records that you require be kept online. Documentation on how to move the sys.aud$ table out the system tablespace is documented, I believe, in the Oracle7 Server Admin. Guide. If my memory serves me it goes something like this.  

1. Export the sys.aud$
2. Alter user SYS' default tablespace to the new tablespace that is to contain the aud$ table.
3. Drop the aud$ table.
4. Import the previously exported aud$ table.
5. Alter user SYS' default tablespace back to SYSTEM.

There may be one fine point that I'm forgetting to cover here.  If you want, you can contact me directly at (810)244-4719 during normal business hours
and I'd be glad to look up my notes on how I did this.  

One other option is to create a script that is controlled by cron that periodically extracts say a certain date range of audit records and insert them into an historical type of audit table you create. This same job would then delete from the sys.aud$ those records copied to the historical table.  

Hope this helps, Dennis Received on Wed Apr 19 1995 - 00:00:00 CEST