Error when initialize the cleanup of the audit tables
Hi all,
My db version is : 11.1.0.7.0 64 bit on Linux.
I configure my db to auto purge audit data (I also test and success on same db version).
I were create a tablespace with name is AUDIT_AUX and size is 3G (with option is AUTOEXTEND). After that, I move two tables AUD$ and FGA_LOG$ to new this tablespace and moving success, I used script to check location:
And result is:SELECT table_name, tablespace_nameFROM dba_tablesWHERE table_name IN ('AUD$', 'FGA_LOG$')ORDER BY table_name;
After that, I initialize the cleanup of the audit tables via dbms_audit_mgmt package by script:AUD$ AUDIT_AUXFGA_LOG$ AUDIT_AUX
0