RE: Audit Purge Script

Am I loosing something here by not using the dbms_audit_mgmt package over 
deleting from sys.aud$ directly?   The adump records are managed by a cleanup 
script that works in all the dump dirs for 10g, and 11g keeps one year by 
default if I am not mistaken.

So given the choice between the two, I have to be missing something or there 
would be no reason to go through all that and move the data to a new tablespace 
to boot>

Joel Patterson
Database Administrator
904 727-2546

-----Original Message-----
From: Martin Berger [mailto:martin.a.berger@xxxxxxxxx] 
Sent: Friday, March 30, 2012 2:10 PM
To: Patterson, Joel
Cc: nagaraj.chk@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: Audit Purge Script

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
> --
> http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l


Other related posts: