Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-01552: cannot use system rollback segment for non-system
tablespace 'string'
- 1 Answers
- 3818 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-16150: FINISH recovery performed on another, older standby database
ORA-24013: invalid value string, RETRY_DELAY should be non-negative
ORA-12323: unable to open database (link name string)
IMG-00609: unable to read image stored in a BFILE
EXP-00018: datatype (number) for column string, table string.string is not supported
RMAN-12018: channel string disabled, job failed on it will be run on another channel
RMAN-06378: List of Backup Sets
NNL-00301: Server shutting down
ORA-14177: STORE-IN (Tablespace list) can only be specified for a LOCAL index on a Hash or Composite Range Hash table
TNS-01177: Log Status is OFF. Log file/directory unchanged
ORA-07643: smsalo: SMSVAR is invalid
LPX-00404: unable to resolve namespace URI
Oracle Errors 
