No question at this time
DBA Top 10
1 M. Cadot 13000
2 B. Vroman 7000
3 A. Kavsek 5900
4 J. Schnackenberg 3200
5 P. Wisse 2600
6 J. PĂ©ran 2200
7 T. Boles 600
8 Z. Hudec 400
8 G. Lambregts 400
8 N. Havard 400
8 F. Pachot 400
8 D. Dave 400
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48600
Total active users1396
Act. users last 24h1
Act. users last hour0
Registered user hits last week51
Registered user hits last month385
Go up

How to clean up older records in AUD$ table
Next thread: Data Migration
Prev thread: RMAN ERROR

Message Score Author Date
Hi Folks, I am looking for a process to trunca...... Jayanand Reddy Jan 17, 2014, 11:18
Anand, How about the documentation? http://doc...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Philip Wisse Jan 17, 2014, 11:25
Mr. Reddy Purging a Subset of Records from the ...... Score: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 Pts prashansh kumar Jan 17, 2014, 11:28
Thanks prashansh kumar Your post is really help...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Jayanand Reddy Jan 17, 2014, 12:24
Hi Philip Wisse, The link which you have posted...... Jayanand Reddy Jan 17, 2014, 12:26
Truncate and delete are different things. Please s...... Adam Hudspith Jan 17, 2014, 12:26
Hello Anand, one small thing to know: if you de...... Bruno Vroman Jan 17, 2014, 14:31

Follow up by mail Click here


Subject: How to clean up older records in AUD$ table
Author: Jayanand Reddy, India
Date: Jan 17, 2014, 11:18, 2652 days ago
Os info: CentOS release 5.7 (Final)
Oracle info: 11.2.0.3.0
Message: 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
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: How to clean up older records in AUD$ table
Author: Philip Wisse, Netherlands
Date: Jan 17, 2014, 11:25, 2652 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Anand,

How about the documentation?
http://docs.oracle.com/cd/E11882_01/network.112/e10574/auditing.htm#DBSEG90934

Regards, Philip
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: How to clean up older records in AUD$ table
Author: prashansh kumar, India
Date: Jan 17, 2014, 11:28, 2652 days ago
Score:   Score: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 Pts
Message: Mr. Reddy

Purging a Subset of Records from the Database Audit Trail

You can manually remove records from the database audit trail tables. This method can be useful if you want to remove a specific subset of records. You can use this method if the database audit trail table is in any tablespace, including the SYSTEM tablespace.

For example, to delete audit records that were created later than the evening of February 28, 2009 but before March 28, 2009, enter the following statement:

DELETE FROM SYS.AUD$
WHERE NTIMESTAMP# > TO_TIMESTAMP ('28-FEB-09 09.07.59.907000 PM') AND
NTIMESTAMP# < TO_TIMESTAMP ('28-MAR-09 09.07.59.907000 PM');
Alternatively, to delete all audit records from the audit trail, enter the following statement:

DELETE FROM SYS.AUD$;
Only the user SYS or a user to whom SYS granted the DELETE privilege on SYS.AUD$ can delete records from the database audit trail.
Regards
Prashansh
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: How to clean up older records in AUD$ table
Author: Jayanand Reddy, India
Date: Jan 17, 2014, 12:24, 2652 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: Thanks prashansh kumar

Your post is really help me allot.

Is it possible to truncate records in AUD$ table for particular date using this below package

DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL.

Thanks,
Anand T
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: How to clean up older records in AUD$ table
Author: Jayanand Reddy, India
Date: Jan 17, 2014, 12:26, 2652 days ago
Message: Hi Philip Wisse,

The link which you have posted is really good.

Thanks,
Anand T
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: How to clean up older records in AUD$ table
Author: Adam Hudspith, United Kingdom
Date: Jan 17, 2014, 12:26, 2652 days ago
Message: Truncate and delete are different things. Please stop confusing the terms.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: How to clean up older records in AUD$ table
Author: Bruno Vroman, Belgium
Date: Jan 17, 2014, 14:31, 2652 days ago
Message: Hello Anand,

one small thing to know: if you delete rows from AUD$ from a session run by a user that is not "SYS", then the "delete from aud$ where ..." command itself is audited and cannot be deleted by the user.
Only SYS can delete those rows (for example with
  DELETE aud$
      WHERE action# = 7
          AND obj$name = 'AUD$'
          AND returncode = 0
  ;
)

Best regards,

Bruno Vroman.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here