ORA-01552: cannot use system rollback segment for non-system
tablespace 'string'
- 1 Answers
- 3961 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 |
NZE-29176: CRL signature verification failed
ORA-39023: Version string is not supported.
ORA-16035: missing required keyword string
ORA-26714: User error encountered while applying
QSM-02144: aggregate functions are present without a GROUP BY clause
ORA-36677: (XSDPART15) Duplicate value in value lists of number and number
ORA-26708: remote DDL not supported by STREAMS : dblink string
ORA-06035: NETDNT: connect failed, insufficient resources
ORA-09978: skxfqhdel: Error Disconnecting from another endpoint.
ORA-01051: deferred rpc buffer format invalid
ORA-08459: invalid format parameter length
TNS-12658: ANO service required but TNS version is incompatible
Oracle Errors 
