Re: Audit Purge Script

From: Nagaraj S <nagaraj.chk_at_gmail.com>
Date: Fri, 30 Mar 2012 04:14:27 +0530
Message-ID: <CAG6s0C2N6g2qB6s3UO8o-nFUAcDkGi6AUYc4b4tZU7oh3AE5wg_at_mail.gmail.com>

okay thank you
On Fri, Mar 30, 2012 at 4:13 AM, kathryn axelrod <kat.axe_at_gmail.com> wrote:

> 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:44:27 CDT