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