| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: help for rollback segments..
to create them as private, the syntax is:
create rollback segment .......
you don't need the work "private" in there.
for the ones that are offline try:
alter rollback segment <segment name> online;
and see if the status changes.
>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: Re: help for rollback segments..
>Date: Sun, 10 Jun 2001 22:15:25 -0800
>
>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).
-- 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).Received on Mon Jun 11 2001 - 08:00:53 CDT
 |
 |