Home » RDBMS Server » Server Administration » rollback segment
rollback segment [message #56272] Sun, 16 March 2003 04:29 Go to next message
Haitham AlQasm
Messages: 2
Registered: March 2003
Junior Member
How to bring all rollback segments(include system generated segments) online on oracle9i while the UNDO_MANAGEMENT parameter set to auto?
Re: rollback segment [message #56276 is a reply to message #56272] Sun, 16 March 2003 22:36 Go to previous message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
Hi,

You do not need to bring any rollback segments on-line when UNDO_MANAGEMENT=AUTO. Oracle will create and manage its own undo segments. Undo segments perform the same function as rollback segments.

Best regards.

Frank
Previous Topic: Move Oracle Control File
Next Topic: insert hanging on 40GB table in Oracle / NT
Goto Forum:
  


Current Time: Thu Sep 19 22:40:49 CDT 2024