Ora-701 Error Moving Tables Back To System Tablespace

Posted by PDSERVICE on Nov 15, 2015 In

Ora-701 Error Moving Tables Back To System Tablespace

When trying to move a SYS owned object back to the SYSTEM tablespace, fails with the following error.

SQL> alter table SYS."FIXED_OBJ$" move tablespace system;

alter table SYS."FIXED_OBJ$" move tablespace sysaux

ERROR at line 1:

ORA-00701: object necessary for warmstarting database cannot be altered

- This occurred during a migration because SYS's default tablespace was not SYSTEM.

SOLUTION

The table involved here is considered a bootstrap object, so DDL is prevented on this object. To fix this situation by permitting object to be moved back to SYSTEM tablespace, you must

start the database in MIGRATE mode. Here are the steps to accomplish.

You are here

Ora-701 Error Moving Tables Back To System Tablespace

Ora-701 Error Moving Tables Back To System Tablespace

SOLUTION