Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-01552: cannot use system rollback segment for non-system
tablespace 'string'
- 1 Answers
- 3824 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 |
RMAN-08584: copying current controlfile
ORA-29872: parameters clause cannot be combined with the specified options
RMAN-03004: fatal error during execution of command
ORA-14455: attempt to create referential integrity constraint on temporary table
ORA-31161: element or attribute "string" cannot be stored out of line
ORA-10918: TABLESPACE GROUP name cannot be the same as tablespace name
SQL-02104: Inconsistent host cache. No cursor cache available
RMAN-06510: RMAN retention policy is set to recovery window of number days
IMG-00857: area list free failed
ORA-25457: evaluation function string returns failure
ORA-28502: internal communication error on heterogeneous database link
SQL*Loader-00528: OCI return status: error
Oracle Errors 
