Email: service@parnassusdata.com 7 x 24 online support!

Home

DOWNLOAD DBRECOVER

Ora-701 Error Moving Tables Back To System Tablespace

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.