Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-01552: cannot use system rollback segment for non-system
tablespace 'string'
- 1 Answers
- 3726 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-36640: (XSDUNION19) Concat dimension workspace object cannot be changed to UNIQUE because base dimension workspace object does not have a TEXT or ID datatype.
ORA-01940: cannot drop a user that is currently connected
ORA-02165: invalid option for CREATE DATABASE
PCC-00126: Could not find or open system configuration file
SQL*Loader-00607: partition not empty for INSERT option; table string, partition string
ORA-07570: szrfc: $IDTOASC failure
ORA-31455: nothing to ALTER
ORA-10636: ROW MOVEMENT is not enabled
ORA-09878: sstascre/sstasat: shmat error, unable to attach tas write page
ORA-28169: unsupported certificate type
ORA-30432: summary 'string.string' is in INVALID state
EXP-00020: failed to allocate memory of size number
Oracle Errors 
