Home » RDBMS Server » Server Administration » alter rollback segment (10g,NT)
alter rollback segment [message #309277] Wed, 26 March 2008 23:55 Go to next message
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 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: ORA-20000: index "SYS"."WRH$_ACTIVE_SESS_HIST_PK"
Next Topic: SGA MAX SIGE
Goto Forum:
  


Current Time: Sun Dec 04 10:44:32 CST 2016

Total time taken to generate the page: 0.03864 seconds