Re: help for rollback segments..

hi rachel,

i recreated them in rbs tablespace, created all right. i created them as public segments. i tried to give them private. but create private rollback segment rbs1... failed.
how i could create them private.
after creating them as public, some are still shown as offline. when i tried to include them in init.ora file as..
rollback segments =(1,2,3,....)
it again failed to start the server..

right now it's working fine, but some are shown as offline.

what to do. any idea.

thanks
saurabh
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Friday, June 08, 2001 8:47 PM

> the rollback segments are offline because they are
> 1) not mentioned in the init.ora file (which would cause them to be
> automatically brought online when you start the database)
> 2) because you did not bring them online when they were created
> 3) ones you specifically took offline
>
> I would change the tablespace they exist in (except for the ones named
> SYSTEM, SYSROL, RB0 and RB1) from SYSTEM to RBS. Unfortunately, the only
> way I know of to do that is to take them offline and drop them, then
> recreate them and bring them online.
>
> Why are they in SYSTEM? Because when they were created no tablespace was
> specified and they were created in the SYSTEM tablespace.
>
>
> >From: "Saurabh Sharma" <ssharma1_at_fcsltd.com>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >Subject: help for rollback segments..
> >Date: Thu, 07 Jun 2001 23:15:23 -0800
> >
> >HI ALL,
> >
> >i've some confusion regarding rollback segments. could anyone explain
this
> >information from my database.
> >
> >select * from dba_rollback_segs revealed following stats..
> >
> >SEGMENT_NAME OWNER TABLESPACE INITIAL_EX NEXT_EXTEN MIN_EXTENT
MAX_EXTENT
> >PCT_INCREA STATUS
>
>------------- ------ ---------- ---------- ---------- ---------- ----------
> >---------- -------
> >SYSTEM SYS SYSTEM 57344 57344 2
505
> > 0 ONLINE
> >SYSROL SYS SYSTEM 106496 106496 2
505
> > 0 OFFLINE
> >RB0 PUBLIC RBS 106496 262144 2
121
> > 0 ONLINE
> >RB1 PUBLIC RBS 106496 262144 2
121
> > 0 ONLINE
> >RB_TEMP SYS SYSTEM 106496 106496 2
121
> > 0 OFFLINE
> >RB2 PUBLIC SYSTEM 57344 262144 2
121
> > 0 ONLINE
> >RB3 PUBLIC SYSTEM 57344 262144 2
121
> > 0 ONLINE
> >RB4 PUBLIC SYSTEM 57344 262144 2
121
> > 0 ONLINE
> >RB5 PUBLIC SYSTEM 57344 262144 2
121
> > 0 ONLINE
> >RB6 PUBLIC SYSTEM 57344 262144 2
121
> > 0 ONLINE
> >RB7 PUBLIC SYSTEM 57344 262144 2
121
> > 0 ONLINE
> >RB8 PUBLIC SYSTEM 57344 262144 2
121
> > 0 ONLINE
> >RB9 PUBLIC SYSTEM 57344 262144 2
121
> > 0 ONLINE
> >RB10 PUBLIC SYSTEM 57344 262144 2
121
> > 0 ONLINE
> >RB11 PUBLIC SYSTEM 57344 262144 2
121
> > 0 ONLINE
> >RB12 PUBLIC SYSTEM 57344 262144 2
121
> > 0 ONLINE
> >RB13 PUBLIC SYSTEM 57344 262144 2
121
> > 0 ONLINE
> >RB14 PUBLIC SYSTEM 57344 262144 2
121
> > 0 OFFLINE
> >RB15 PUBLIC SYSTEM 57344 262144 2
121
> > 0 OFFLINE
> >RB16 PUBLIC SYSTEM 57344 262144 2
121
> > 0
> >
> >can anybody explain, why i get some status as offline. will this extent
> >allocation and other parameters ok. i 've oracle 8.1.5 on NT, these stats
> >are from my test database.
> >why are they in system tablespace. i've two rollback tablespace of size
15
> >and 20 mb resp.
> >should they be in system or in rollback.
> >if yes, how to change their default tablespace.
> >
> >pls help me in deciding that.
> >
> >thanks in advance.
> >
> >saurabh
> >
> >
>
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rachel Carmichael
> INET: carmichr_at_hotmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Saurabh Sharma
  INET: ssharma1_at_fcsltd.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).