| 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..
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
>
>
-- 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 Fri Jun 08 2001 - 09:15:01 CDT
 |
 |