Re: aud$ delete
Date: Mon, 22 Mar 2010 09:17:50 -0400
Message-ID: <OF05BC1971.BB9B417C-ON852576EE.0048E350-852576EE.00490BA0_at_lazard.com>
Hi J. Dex,
Which user are you using to delete/truncate from aud$ table. Starting 10g only sys (sysdba) can delete from aud$ table.
- Mayen
"J. Dex" <cemail_219_at_hotmail.com>
Sent by: oracle-l-bounce_at_freelists.org
Mar 22 2010 09:13 AM
Please respond to
cemail_219_at_hotmail.com
To
oracle-l_at_freelists.org
cc
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://www.freelists.org/webpage/oracle-lReceived on Mon Mar 22 2010 - 08:17:50 CDT