Rollback Segment is OFFLINE

hi,

I have just now created a larger rollback segment to handle a bulk deletes.

I issued this command


SQL> create public rollback segment
large_rbs tablespace RBS
STORAGE
(INITIAL 10M
NEXT 5M
MAXEXTENTS UNLIMITED)

Rollback segment created.

SQL> set transaction use rollback segment large_rbs;
set transaction use rollback segment large_rbs
*
ERROR at line 1:
ORA-01598: rollback segment 'LARGE_RBS' is not online

HOW DO I BRING THIS LARGE_RBS ONLINE;
badrinath

alter rollback segement rb_name online;
-
Make sure you include this rbs in the init.ora, else it will be offline whenever you bounce the db.

[Edited by Halo on 02-27-2001 at 01:45 PM]

Hi,
Ur problem is that the rollback segment u created is offline and should be brought online for use.In Oracle whenever u create a rollback segment it is offline by default.So u have to bring it online in order to use it.
The following syntax will bring the rollback segment online.
SQL>ALTER ROLLBACK SEGMENT ONLINE;

U can place the name of the rollback segment in ur init.ora parameter file
ROLLBACK_SEGMENTS=(rbs1,rbs2,rbs3) and restart the instance.
If u do so then when ur database is started the named rollback segments will automaically be brought online,instead of bringing them online each one-by-one

If u have any doubts,please be free to ask me at
rohitsn@orasearch.net

Regards,
Rohit Nirkhe,Oracle DBA,OCP

u have created the large rollback segment but u havn't made it online. issue the following command:-
alter rollback segment online;
issue the rollback or commit command
then issue the statment
set transaction use rollback segment;

if u have any more queries contact me
all the best

shirish

Quote:

---

Originally posted by badrinathn
hi,

I have just now created a larger rollback segment to handle a bulk deletes.

I issued this command


SQL> create public rollback segment
large_rbs tablespace RBS
STORAGE
(INITIAL 10M
NEXT 5M
MAXEXTENTS UNLIMITED)

Rollback segment created.

SQL> set transaction use rollback segment large_rbs;
set transaction use rollback segment large_rbs
*
ERROR at line 1:
ORA-01598: rollback segment 'LARGE_RBS' is not online

HOW DO I BRING THIS LARGE_RBS ONLINE;
badrinath

---