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;