Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-01552: cannot use system rollback segment for non-system
tablespace 'string'
- 1 Answers
- 3807 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 |
NNL-00232: Auto-refresh failure-retry interval is currently string
TNS-12231: TNS:No connection possible to destination
ORA-12076: invalid threshold value
ORA-13498: %s
ORA-02299: cannot validate (string.string) - duplicate keys found
EXP-00002: error in writing to export file
ORA-28553: pass-through SQL: invalid bind-variable position
ORA-01029: internal two task error
ORA-37040: (XSACQUIRE_DEP_LOCKED) Composite, concat, dimension map, or internal partition workspace object is locked by another user.
ORA-01275: Operation string is not allowed if standby file management is automatic.
ORA-16167: LGWR network server could not switch to non-blocking mode
ORA-32301: object-relational materialized views must be primary key based
Oracle Errors 
