RE: Audit Purge Script

  • From: <Joel.Patterson@xxxxxxxxxxx>
  • To: <martin.a.berger@xxxxxxxxx>, <nagaraj.chk@xxxxxxxxx>
  • Date: Fri, 30 Mar 2012 13:32:12 -0400

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


Other related posts: