Rollback Segment is OFFLINE

[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

[Halo]

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]

[rohitsn]

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

[shirishck]

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

if u have any more queries contact me
all the best

shirish
[QUOTE][i]Originally posted by badrinathn [/i]
[B]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

[/B][/QUOTE]