ORA-01552: cannot use system rollback segment for non-system
tablespace 'string'
- 1 Answers
- 3342 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 |
SQL*Loader-00401: End field position number must be greater than or equal to start number
NNO-00702: cache checkpointing disabled
ORA-13187: subdivision failed
LSX-00294: field "~S" produced multiple hits
ORA-24035: AQ agent string is not a subscriber for queue string
ORA-36206: (XSAGOP04R) In AGGMAP workspace object, REMOPERATOR string must be MIN, MAX, FIRST, LAST, HFIRST or HLAST.
RMAN-06136: ORACLE error from auxiliary database: string
ORA-00117: PROTOCOL, ADDRESS or DESCRIPTION must be specified
ORA-25235: fetched all messages in current transaction
KUP-04030: invalid numeric data
TNS-00310: Navigator: Failed to start tracing after rereading parameter data
RMAN-08584: copying current controlfile
Oracle Errors 
