Database Administration (MOSC)

MOSC Banner

Purget AuditORA-46267 ORA-06512 Circular nonsens?

edited Oct 24, 2016 2:36PM in Database Administration (MOSC) 2 commentsAnswered

Bonjour,

   the size of the table sys.aud$ is reported, by toad, to be of 8.4G in size.

I have manually purge the table to keep only the last 7 days so I went from 47 millions rows to 267 000 rows.

Even after analyze, Toad reports the size to 8.4G.

Now, we all know the size is not 8.4G in real size but,

SQL> BEGIN

DBMS_AUDIT_MGMT.INIT_CLEANUP(

              audit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_ALL,

      default_cleanup_interval => 168/* hours */);

END;

/  2    3    4    5    6 

BEGIN

*

ERROR at line 1:

ORA-46267: Insufficient space in 'SYSAUX' tablespace, cannot complete operation

ORA-06512: at "SYS.DBMS_AUDIT_MGMT", line 1087

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center