ORA-01552: cannot use system rollback segment for non-system
tablespace 'string'
- 1 Answers
- 3071 Views
- I also Faced
- E-Mail Answers
Answer / guest
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 system tablespace. Only the
system rollback segment can be online in a clone database.
Action: Create one or more private/public segment(s),
shutdown and then startup again. May need to modify the
INIT.ORA parameter rollback_segments to acquire private
rollback segment. If this is a clone database being used for
tablspace point in time recovery then this operation is not
allowed. If the non-system tablespace has AUTO segment space
management, then create an undo tablespace.
Please add more information about this Error
| Is This Answer Correct ? | 2 Yes | 0 No |
ORA-09774: osnmui: cannot send break message
NZE-29151: 3DES self-test failure
NID-00134: Datafile "string" is not consistent
RMAN-04032: using contents of file string
DRG-10504: primary key is required when using the DETAIL_DATASTORE
ORA-02289: sequence does not exist
PLS-00900: can't find body of unit 'string'
LSX-00023: unknown namespace URI "~S"
ORA-22613: buflen does not match the size of the scalar
NZE-29032: The given identity is not complete.
ORA-32132: maximum iterations cannot be changed
ORA-32771: cannot add file to bigfile tablespace
Oracle Errors 
