Re: Audit Purge Script
Date: Thu, 29 Mar 2012 15:43:02 -0700
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
...Received on Thu Mar 29 2012 - 17:43:02 CDT