Oracle 11g on RHEL6. The disk is full, the SYSAUX tablespace has grown to 15Gb, and I want to reduce the disk usage. Tricky. I have cleaned up all AWR snapshots, both active and "stuck" or only partly removed by the system. This has reduced the actual usage to 9 Gb, but I cannot free the tablespace to the disk, due to LOBSEGMENT items (owned by XDB user) occupying the high end of the data blocks. Oracle 11g comes with a package containing the procedure XDB.DBMS_XDB_ADMIN_MOVEXDB_TABLESPACE. Running the database in restrict mode, I try to activate this function, moving all tables under the XDB User to a newly added tablespace, on another disk partition.
exec XDB.DBMS_XDB_ADMIN.MOVEXDB_TABLESPACE('XDBDS', TRACE=>TRUE);
This fails.
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at "XDB.DBMS_XDB_ADMIN", line 969
ORA-06512: at line 1
What can be the cause of this ?
Thanks
Tor