ORA-01552: cannot use system rollback segment for non-system tbs
                                                 Last update (2009-11-16 10:00:37)
                                                                                                                   Date added (2009-11-16 09:51:24)

Summary
Tried to use the system rollback segment for operations involving non-system tablespace. Usually this error appears on a Clone database. Only the system rollback segment can be online in a clone database.

Workaround
1. Create a new undo tablespace for example
CREATE UNDO TABLESPACE UNDOTBS DATAFILE '/orandr/ANDR/datafiles_new/undotbs_01.dbf' 
SIZE 1000M AUTOEXTEND OFF;
2. Shutdown the database

Add the following lines to the initSID.ora file
undo_management = 'AUTO'
undo_tablespace = 'UNDOTBS'
undo_retention = 3600
3. Startup the database with the new initSID.ora
Reviews
Filters
Search