Hello,
My tablespace SYSAUX is grown fast and i see that has a tabls CLI_SWP... on it with abut 8GB and another object SYS_LOB.... with about 17GB. I have purged UNIFIED AUDIT with DBMS_AUDIT_MGMT and I would like to know if it´s possible to reduce or move UNIFIED_AUDIT_TRIAL table to release free space.
After purge I execute
SQL> select count(*) from unified_audit_trail;
COUNT(*)
----------
0
But the query runs about 50 seconds before show result.
I tried to change tablespace with:
BEGIN
DBMS_AUDIT_MGMT.set_audit_trail_location(
audit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_UNIFIED,
audit_trail_location_value => 'AUDITTBS');
END;
but returns:
Error report:
ORA-46099: Feature unsupported or not implemented
ORA-06512: at "SYS.DBMS_AUDIT_MGMT", line 4274
ORA-06512: at "SYS.DBMS_AUDIT_MGMT", line 488
ORA-06512: at line 2
Is possible to reduce table or i need to recreate de database instance?