This discussion is archived
3 Replies Latest reply: Nov 8, 2012 8:54 AM by cobragurl RSS

audit purging error in DBMS_AUDIT_MGMT.init_cleanup

709698 Newbie
Currently Being Moderated

Im in a process of enhancing my audit tables usage by using following document,

Im running oracle on SunOS. My AUD$ and FGA_LOG$ tables were on SYSTEM tablespace and I moved them to a newly created AUDIT_AUX tablespace as per the above documents first step says (Moving the Database Audit Trail to a Different Tablespace).

And then after that, when I do the Initializing using DBMS_AUDIT_MGMT.init_cleanup package it gives following errors.

ORA-46267: Insufficient space in 'SYSAUX' tablespace, cannot complete operation
ORA-06512: at "SYS.DBMS_AUDIT_MGMT", line 1087
ORA-06512: at line 2

when I go through oracle note [804624.1] it says that, when I run the init_cleanup it checks for space in SYSAUX tablespace. But the thing is I've already moved the audit tables to AUDIT_AUX tablespace.
- I just want to know is it tries to move AUD$ and FGA_LOG$ to SYSAUX tablespace or is it just checks for the space?
- Is it possible for me to just increase the SYSAUX tablespace size as it needs and resize it to previous level after init_cleanup done?



  • Correct Answers - 10 points
  • Helpful Answers - 5 points