I would like reduce my tablespace SYSAUX by resize ORA-03297
hello,
I would like resize my sysaux tablespace.
1 - i have executed : BEGIN
DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL(
AUDIT_TRAIL_TYPE => DBMS_AUDIT_MGMT.AUDIT_TRAIL_UNIFIED,
USE_LAST_ARCH_TIMESTAMP => FALSE,
CONTAINER => dbms_audit_mgmt.container_current);
END;
/
2 - I am seeing that it is good.
TABLESPACE MAXSIZE MB Allocated MB Free MB Used MB EXT %Used
-------------------- ---------- ------------ ---------- ---------- ---------- -------
SYSAUX 65536 34820 28862 5958 1287 17.11
SYSTEM 65536 1990 7 1983 3 99.67
TEMP 0 77824 11072 66752 2 85.77
UNDOTBS1 0 61440 42700 18740 187 30.50
Then i see that i may reduce my datafile SYSAUX 28862
3 - i executed my statment :
alter database datafile '/u02/oradata/DBUR2I40/sysaux01DBUR2I40.dbf' resize 25000M;
and i have this next error :