Thread: Managing Rollback segment in database

I am getting error during design of table in database and the error is as follows:

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

When I go ahead to create the rollback segment for USERS tablespace,It happen some error again which is below

ORA-30574: Cannot create rollback segment in tablespace with AUTO segment space
management

Can someone help and suggest me regarding this.
Thanks.

Code:

CREATE TABLESPACE Rollbsc_tabs
   DATAFILE 'Rollbsc_tabs.dbf' SIZE 20M
   EXTENT MANAGEMENT LOCAL UNIFORM SIZE 120K;

And then design a rollback segment which would be saved and managed by above designed tablespace.

Code:

CREATE ROLLBACK SEGMENT Rollbsc_frst
   TABLESPACE Rollbsc_tabs;

Using DROP ROLLBACK segment, you can drop the rollback segment from the database, during deletion of rollback segment, the space taken by rollback segment is returned back to the tablespace:

To drop the rollback segment:

Code:

DROP ROLLBACK SEGMENT <name_of_rollbacksegment>;