Managing Rollback segment in database

GonzalezBrown · 02-09-2010, 04:35 PM

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.

LewisClark · 02-09-2010, 04:37 PM

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;

WalkerCook · 02-09-2010, 04:39 PM

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>;

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Database Normalization in SQL Database	Millerjames	Programming	1	01-23-2010 02:17 PM
Google posts profit in the fourth segment	PowellParker	Latest Hardware News	0	01-23-2010 01:31 PM
Fermi for the ground segment will appear at the end of the first quarter of 2010	leshter	Latest Hardware News	0	10-17-2009 06:55 AM
ARM will replace Intel in the segment of netbooks and smartbook	david harlow	Latest Hardware News	0	09-30-2009 05:51 AM
Software make to the Enterprise segment	simona	General Software Terms	1	04-06-2009 07:47 AM