Naga Purge Aud$ table depends on your need. I would recommend to archive Aud$ table data, then we need to think about purge. There must be reason you enabled auditing but purging Aud$ will loose that data. Came across following blog entry with archive and purge Aud$ http://ulfet.blogspot.com/2013/02/archive-and-purge-aud-table.html?m=1 HTH Karth On Aug 9, 2013, at 12:54 AM, Nagaraj S <nagaraj.chk@xxxxxxxxx> wrote: > Hello Gurus, > I have a task to purge aud$ table and it need to done in automated way > on every month. Please help on sharing the purge script to schedule in db > scheduler > > -Naga > > > -- > //www.freelists.org/webpage/oracle-l > > -- //www.freelists.org/webpage/oracle-l