Posted on 2007-03-29
when I try to create a new table i got below error... i was looking at the action statement..but i am quite sure how to do this... can you show me the step by step instruction?
SQL Error: ORA-01552: cannot use system rollback segment for non-system tablespace 'GTABLES'
01552. 00000 - "cannot use system rollback segment for non-system tablespace '%s'"
*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
*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.