ORA-01552: cannot use system rollback segment for non-system
tablespace 'string'
- 1 Answers
- 3048 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-06790: TLI Driver: poll failed
ORA-30386: invalid SQL statement for DECLARE_REWRITE_EQUIVALENCE
SQL-02124: NULL value returned by EXEC TOOLS statement
RMAN-06290: Report of database schema
ORA-09812: Unable to get user clearance from connection
ORA-15103: conflicting or duplicate REPAIR options
ORA-15001: diskgroup "string" does not exist or is not mounted
ORA-08264: ora_addr: cannot close nameserver
ORA-23363: mismatch of mview base table "string" at master and mview site
ORA-13346: the coordinates defining an arc are collinear
NNL-00833: Fastest delete processing time: string
ORA-24439: success with PLSQL compilation warning
Oracle Errors 
