The Oracle docs note this on the ora-01552 error:

ORA-01552: cannot use system rollback segment for non-system tablespace "string"

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.

On Oracle DBA Forums , user Chris_Pena encountered ORA-01552 while using this SQL statement:

SQL> select segment_name, status from dba_rollback_segs;

SEGMENT_NAME STATUS
------------------------------ ----------------
SYSTEM ONLINE
_SYSSMU1$ OFFLINE
_SYSSMU2$ OFFLINE
_SYSSMU3$ OFFLINE
_SYSSMU4$ OFFLINE
_SYSSMU5$ OFFLINE
_SYSSMU6$ OFFLINE
_SYSSMU7$ OFFLINE
_SYSSMU8$ OFFLINE
_SYSSMU9$ OFFLINE
_SYSSMU10$ OFFLINE

As a response, Burleson reminded the user that you cannot force a SQL in system RBS. Because of this, to avoid ORA-01552 he should have created public rollback segments, and resolved the current issue by trying to undo (depending on the release in use).

ITPub博客

01552解决

最新文章