Re: Audit Purge Script

From: kathryn axelrod <kat.axe_at_gmail.com>
Date: Thu, 29 Mar 2012 15:43:02 -0700
Message-ID: <CAEbHM44tWHwgwu4oNPa8EzjBbeqgp-QTtNGL2C=kef16K5WT+A_at_mail.gmail.com>

I haven't used this particular procedure, but based on how it is written, yes; if run as below, it should delete everything older than 90 days.

That said, as I'm a bit uptight about what runs on prod, I'd always vote to test it - even just by running the proc manually - before scheduling it on any system important enough to keep 90days of audit logs.

On Thu, Mar 29, 2012 at 3:25 PM, Nagaraj S <nagaraj.chk_at_gmail.com> wrote:
> Thank You i got it. I use below procedure to schedule the job and my
> understanding is
>  job_action => 'begin purge_audit_trail(90); end;',  --> the purge will keep
> only 90 days record. Plz correct me if i am wrong
>

...

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Mar 29 2012 - 17:43:02 CDT