Purget AuditORA-46267 ORA-06512 Circular nonsens?
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