Forum Stats

  • 3,782,436 Users
  • 2,254,645 Discussions
  • 7,880,078 Comments

Discussions

Purging SYSAUX tablespace, moving XDB owned data fails

user6792477
user6792477 Member Posts: 1 Green Ribbon
edited Nov 26, 2021 10:29AM in Storage General Discussion

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