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

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

Rollback Segment is used by Oracle to undo the changes made by transactions.  UNDO_MANAGEMENT initialization parameter is set to MANUAL then this works.

Error:

SQL> CREATE ROLLBACK SEGMENT roll_segment1
  2  TABLESPACE rollback_tbs;
CREATE ROLLBACK SEGMENT roll_segment1
*
ERROR at line 1:
ORA-01552: cannot use system rollback segment for non-system tablespace rollback_tbs

Solution: To avoid the error, we need to create a rollback segment in dictionary-managed tablespace or system tablespace.

Create a temp rollback segment in tablespace SYSTEM or dictionary-managed tablespace for avoid the error:

SQL> CREATE ROLLBACK SEGMENT rbs_tbs
 TABLESPACE system
;

SQL> ALTER ROLLBACK SEGMENT rbs_tbs ONLINE;


--Now you can create your tablespace which give error:
SQL> CREATE ROLLBACK SEGMENT roll_segment1 TABLESPACE rollback_tbs;

SQL> ALTER ROLLBACK SEGMENT roll_segment1 ONLINE;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.