Joel, you are right, it's not easy. Maybe it helps to understand: It's a spin off from Audit Vault, after some iterations and requests Oracle decided to make it available for non-Audit-Vault customers as well. In my current situation it's quite convenient to implement it at every new created DB - so audit is in place 'just in case' :) Martin On Fri, Mar 30, 2012 at 19:32, <Joel.Patterson@xxxxxxxxxxx> wrote: > The problem I had to wrestle with when considering dbms_audit_mgmt was that > the audit table needs to be moved to an entirely new tablespace... which I > believe comes with upgrade details. > > I kathryn's script works and does the job just as good, it certainly is > easier. All the code in this doc ID seems to be an awful lot when compared > scheduling this simple script. > > Joel Patterson > Database Administrator > 904 727-2546 > > -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On > Behalf Of Martin Berger > Sent: Friday, March 30, 2012 3:13 AM > To: nagaraj.chk@xxxxxxxxx > Cc: oracle-l > Subject: Re: Audit Purge Script > > maybe you want to read > SCRIPT: Basic example to manage AUD$ table in 11.2 with > dbms_audit_mgmt [ID 1362997.1] > in MetaLink. > > hth, > Martin > > On Thu, Mar 29, 2012 at 22:45, Nagaraj S <nagaraj.chk@xxxxxxxxx> wrote: >> Kindly give me steps that need to schedule Audit Purge Job for purging the >> table SYS.AUD$ records more than 90 days > -- > //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l