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" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
