Re: Audit Purge Script

From: kathryn axelrod <>
Date: Thu, 29 Mar 2012 15:43:02 -0700
Message-ID: <>

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 <> 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

Original text of this message