Im in a process of enhancing my audit tables usage by using following document,
Im running oracle 188.8.131.52 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?
As per the link, can you check the below before you do clean up
SELECT * FROM dba_audit_mgmt_config_params;
And also enable the debug before you call DBMS_AUDIT_MGMT.INIT_CLEANUP
DEBUG_LEVEL => TRACE_LEVEL_DEBUG);
Edited by: vreddy on Aug 22, 2012 3:12 PM
There may be chance that table AUD$ exists in two schema i.e. SYS & SYSTEM. Can you pl. post the output of the following query.
select owner, table_name, tablespace_name
where table_name = 'AUD$';