| 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: How to make undeo rollback segment ON-LIne?
Mike,
You can not do that with Automatic Undo Segments.
Can you please check if undo_tablespace is set properly?
It looks like it is not set, and SYSTEM tablespace is being used for undo segments.
Here is how I simulated your query on my test database:
SQL> select segment_name, status from dba_rollback_segs;
SEGMENT_NAME STATUS ------------------------------ ---------------- SYSTEM ONLINE
_SYSSMU1$ ONLINE
_SYSSMU2$ ONLINE
_SYSSMU3$ ONLINE
_SYSSMU4$ ONLINE
_SYSSMU5$ ONLINE
_SYSSMU6$ ONLINE
_SYSSMU7$ ONLINE
_SYSSMU8$ ONLINE
_SYSSMU9$ ONLINE
_SYSSMU10$ ONLINE
11 rows selected.
SQL> alter system set undo_tablespace=''; <---- Unsetting it.
System altered.
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.
SQL> alter system set undo_tablespace='SYS_UNDOTS';
System altered.
SQL> select segment_name, status from dba_rollback_segs;
SEGMENT_NAME STATUS ------------------------------ ---------------- SYSTEM ONLINE
_SYSSMU1$ ONLINE
_SYSSMU2$ ONLINE
_SYSSMU3$ ONLINE
_SYSSMU4$ ONLINE
_SYSSMU5$ ONLINE
_SYSSMU6$ ONLINE
_SYSSMU7$ ONLINE
_SYSSMU8$ ONLINE
_SYSSMU9$ ONLINE
_SYSSMU10$ ONLINE
11 rows selected.
HTH,
-----Original Message-----
Sent: Monday, April 14, 2003 2:29 PM
To: Multiple recipients of list ORACLE-L
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.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: kirti.deshpande_at_verizon.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 - 22:58:38 CDT
 |
 |