| alter rollback segment [message #309277] |
Wed, 26 March 2008 23:55  |
sidd_411
Messages: 30
Registered: March 2008
|
Member |
|
|
Hi,
I am trying to make some rollback segments to offline, but it is not happening. Can anyone guide me. Find below the commands;
SQL> alter rollback segment SYSSMU1 offline;
Rollback segment 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.
SQL>
|
|
|
|
| Re: alter rollback segment [message #309323 is a reply to message #309277] |
Thu, 27 March 2008 02:09  |
 |
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
You are using automatic undo management feature, why do you want to manage the undo/rollback segments?
Either you are automatic, either you are manual, you can't be both.
Don't touch these segments.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
