Jump to Navigation

302 - ORA-46267 DBMS_AUDIT_MGMT.init_cleanup

1. ORA-46267: Insufficient space in 'string' tablespace, cannot complete operation

Cause: Could not complete the operation because the DBMS_AUDIT_MGMT API involved movement of one
           or more audit tables and there was not enough space in the destination tablespace.
           Maybe it was SYSAUX or SYSTEM tablespace.

Action: You should extend it as enough space available to purge.

SQL> ALTER TABLESPACE SYSAUX ADD DATAFILE '/u01/app/oracle/oradata/mydb/sysaux02.dbf' size 100M AUTOEXTEND ON NEXT 5M;

 

2. Other solution.

SQL> DELETE FROM SYS.AUD$;
SQL> TRUNCATE TABLE SYS.AUD$;

 

3. UNDO Tablespace

Every Oracle Database must have a method of maintaining information that is used to roll back, or undo,
changes to the database. Such information consists of records of the actions of transactions,
primarily before they are committed. These records are collectively referred to as undo.

 

Oracle:


Main menu 2

Story | by Dr. Radut