OraFAQ Forum: Security » How to clean up older records in AUD$ table

Home » RDBMS Server » Security » How to clean up older records in AUD$ table (DB 11.2.0.3.0, OS Red Hat)

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

How to clean up older records in AUD$ table [message #605993]

Fri, 17 January 2014 04:06

anand.oracle
Messages: 8
Registered: April 2013
Location: Bangalore

Junior Member

Hi Folks,

I am looking for a process to truncate records in AUD$ table
Please Help me how to clean up older records(eg:older than Jan 1 2013) in AUD$ table .

Thanks,
Anand T

Report message to a moderator

Re: How to clean up older records in AUD$ table [message #606022 is a reply to message #605993]

Fri, 17 January 2014 08:54

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.oracle.com/pls/db121/search?remark=quick_search&word=truncate
or
http://www.oracle.com/pls/db121/search?word=delete

https://community.oracle.com/thread/2620878

[Updated on: Fri, 17 January 2014 08:57]

Report message to a moderator

Re: How to clean up older records in AUD$ table [message #606023 is a reply to message #605993]

Fri, 17 January 2014 09:24

John Watson
Messages: 8795
Registered: January 2010
Location: Global Village

Senior Member

dbms_audit_mgmt has facilities for this.

Report message to a moderator

Re: How to clean up older records in AUD$ table [message #606024 is a reply to message #605993]

Fri, 17 January 2014 09:35

Michel Cadot
Messages: 68348
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Same question at: http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=70023&SkipA=0

Report message to a moderator

Previous Topic:	password expiration date as per profile attached
Next Topic:	Is is possible to restrict user's password reset by SELF

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 05 12:30:10 CST 2023