Oracle Audit Table Maintenance
Posted on 2011-09-29
Hello, we have implemented session level auditing of our Oracle payroll application and I'm wondering what is the best practice method to purge some of the data on a routine basis. We are only required to keep a years worth of auditing records and as of right now we have about 2.5 in there. The size of the audit data is actually growing larger than the actual data. We would only be doing this purge once a year.
I'm a SQL Server person, so forgive my Oracle ignorance. :)