-
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 <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
-
rollback segment
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]
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|