RE: aud$ delete

There's also the ntimestamp# column. See ML note 427296.1 : 

 

"In database version 10gR1 and above, the TIMESTAMP# column is obsoleted
in favor of the new NTIMESTAMP# column."

 

mvg,

Jo

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of J. Dex
Sent: maandag 22 maart 2010 14:13
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: