How to clean up older records in AUD$ table

1005886

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

Unknown

Most questions on Oracle have a version dependent answer. When you don't mention your four digit version this increases the chance for an inaccurate answer, or no answer at all.

In 11gR2, Oracle provides a dbms_audit_mgmt package for this purpose.

Please use the online documentation as your first stop to answer your questions.

-----------

Sybrand Bakker

Senior Oracle DBA

1005886

Hi ,

RDBMS:11gr2

Verion:11.2.0.3.0

Can we truncate records in AUD$ for particular date by using this package dbms_audit_mgmt.

Is there any method to truncate records manully

DK2010

Hi,

You can check this Doc for step by step :ORACLE-BASE - Auditing Enhancements (DBMS_AUDIT_MGMT) in Oracle Database 11g Release 2

HTH

Unknown

If I would be pointed to an Oracle facility I don't know I would consult online documentation first.

If YOU would have done so, you wouldn't have asked this question!

-----------------

Sybrand Bakker

Senior Oracle DBA

1005886

Hi,

I looked over so  many online Docs .I couldn't get the clear idea ,so finally I posted here for soultion.

Thanks for treating in such a  way .

Anand T

EdStevens

1005886 wrote:

Hi,

I looked over so  many online Docs .I couldn't get the clear idea ,so finally I posted here for soultion.

Thanks for treating in such a  way .

Anand T

We have no idea what is included in "so  many online Docs".  The specific doc you should be looking at is here: DBMS_AUDIT_MGMT

And specific to your question, DBMS_AUDIT_MGMT

What specific parts of the above are you having difficulty with?  We can help, but only if we know the problem

Of course, there is the older method that should be self-evident.

Your question was "how to clean up older records(eg:older than Jan 1 2013) in AUD$ table"

I assume "clean up" means"delete".  So the question is "how to delete records older than a given date from the AUD$ any table?"

Would it not be

delete from a_table

where a_date_column < to_date('2013-01-01','yyyy-mm-dd');

Gayu0726

You can use the following statement to delete the records in AUD$ < jan 1 2013.

DELETE FROM SYS.AUD$ WHERE NTIMESTAMP# < to_date('01-JAN-2013 00:00:00','DD-MON-YYYY HH24:MI:SS');

You can also schedule jobs to purge the AUD$.

12cdb

If you are more concerned, aud$ can be moved to other tablespace

How To Move The DB Audit Trails To A New Tablespace Using DBMS_AUDIT_MGMT?[Article ID 1328239.1]

it is safe to do.

Pradeep