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
Hi,

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

http://www.oracle-base.com/articles/11g/auditing-enhancements-11gr2.php

Im running oracle 11.2.0.3 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?


Thanks
Asanka

Legend

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