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> startup
No comments:
Post a Comment