Re: Audit Purge Script
- From: Martin Berger <martin.a.berger@xxxxxxxxx>
- To: Joel.Patterson@xxxxxxxxxxx
- Date: Fri, 30 Mar 2012 20:09:43 +0200
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
Other related posts:
