Home » RDBMS Server » Security » How to clean up older records in AUD$ table (DB 11.2.0.3.0, OS Red Hat)
How to clean up older records in AUD$ table [message #605993] Fri, 17 January 2014 04:06 Go to next message
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
Re: How to clean up older records in AUD$ table [message #606022 is a reply to message #605993] Fri, 17 January 2014 08:54 Go to previous messageGo to next message
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 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
dbms_audit_mgmt has facilities for this.
Re: How to clean up older records in AUD$ table [message #606024 is a reply to message #605993] Fri, 17 January 2014 09:35 Go to previous message
Michel Cadot
Messages: 68625
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

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


Current Time: Thu Mar 28 11:48:46 CDT 2024