ORA-01552: cannot use system rollback segment for non-system tablespace “TBS Name”

 

ORA-01552: cannot use system rollback segment for non-system tablespace "string"

Cause: Tried to use the system rollback segment for operations involving non-system tablespace.
 If this is a clone database then this will happen when attempting any data modification 
outside of the UNDOTBS tablespace.


1) Switch to Automatic Undo Management
alter system set undo_management=auto scope=spfile;

2) Restart the database.

SQL> Shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup
Recent Posts

Start typing and press Enter to search