RE: aud$ delete
- From: "Sais, Gene" <Gsais@xxxxxxxxxxxxxxxxxxxx>
- To: "'cemail_219@xxxxxxxxxxx'" <cemail_219@xxxxxxxxxxx>
- Date: Mon, 22 Mar 2010 09:19:24 -0400
delete from aud$ where timestamp# < (SYSDATE - 30) ;
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of J. Dex
Sent: Monday, March 22, 2010 9:13 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: aud$ delete
I have auditing of create session set up on my 10.2.0.4 database. I want to
set up a cron job that will delete all records from aud$ that are older than 30
days but I am having issues with the delete statement as nothing is showing up
in the timestamp field. TRUNC doesn't seem to work either. Does anybody
already have this set up and could let me know what the correct statement is?
________________________________
Hotmail: Trusted email with Microsoft's powerful SPAM protection. Sign up
now.<http://clk.atdmt.com/GBL/go/210850552/direct/01/>
Other related posts:
