How to make undeo rollback segment ON-LIne?

From: mike mon <mccdba_at_yahoo.com>
Date: Mon, 14 Apr 2003 11:29:05 -0800
Message-ID: <F001.00580BB7.20030414112905@fatcity.com>

We have ORACLE 9ir2 with undo tablespace setup. I check the rollback segments it all offline. Does nayone know how to make it online.

Thanks.

SQL> select segment_name, status from
dba_rollback_segs;

SEGMENT_NAME                   STATUS
------------------------------ ----------------
SYSTEM                         ONLINE


_SYSSMU1$                      OFFLINE

_SYSSMU2$                      OFFLINE

_SYSSMU3$                      OFFLINE

_SYSSMU4$                      OFFLINE

_SYSSMU5$                      OFFLINE

_SYSSMU6$                      OFFLINE

_SYSSMU7$                      OFFLINE

_SYSSMU8$                      OFFLINE

_SYSSMU9$                      OFFLINE

_SYSSMU10$                     OFFLINE

11 rows selected.

---

Do you Yahoo!?
Yahoo! Tax Center - File online, calculators, forms, and more http://tax.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: mike mon
  INET: mccdba_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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 Apr 14 2003 - 14:29:05 CDT