OraFAQ Forum: Server Administration » empty the audit tables

Home » RDBMS Server » Server Administration » empty the audit tables

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

empty the audit tables [message #120038]

Tue, 17 May 2005 07:58

patrick
Messages: 83
Registered: December 2000

Member

I put auditing on for the database and then said
SQL>audit create session;

This working fine but how do I empty the tables again for the auditing? There is a loth of information there now and i want to truncate it. How do i do this?

PAtrick

Report message to a moderator

Re: empty the audit tables [message #120042 is a reply to message #120038]

Tue, 17 May 2005 08:14

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/audit.htm#1769

Report message to a moderator

Re: empty the audit tables [message #120178 is a reply to message #120038]

Wed, 18 May 2005 03:23

patrick
Messages: 83
Registered: December 2000

Member

Thank you. The document had the statement i was looking for.

For everybody else the statement is.

SQL> DELETE FROM SYS.AUD$

This is the syntax for emptying the audit table

PAtrick

Report message to a moderator

Previous Topic:	Install Oracle server 9.1 and 9.2 on the same machine on IBM AIX
Next Topic:	Rollback segment

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 02:23:01 CDT 2024