ORA-01552: cannot use system rollback segment for non-system tablespace “string”
Cause: Used the system rollback segment for non-system tablespace operations.
If this is a clone database, this will happen when attempting any data modification outside the UNDOTBS tablespace.
Solution :
1) Switch to Automatic Undo Management
$ sqlplus / as sysdba
alter system set undo_management=auto scope=spfile;
2) Restart the database.
SQL> Shutdown immediate;
SQL> startupComments
Tags: ORA-01552, Oracle DBA, system rollback segment, tablespace, Temp