Home » RDBMS Server » Server Administration » Undo space
Undo space [message #238680] Fri, 18 May 2007 23:56 Go to next message
Messages: 261
Registered: January 2006
Senior Member

My undo tablespace is almost full. How to manually free the unused undo space in Automatic undo management mode?
Please let me know the step,how to do this.

Re: Undo space [message #238686 is a reply to message #238680] Sat, 19 May 2007 00:38 Go to previous message
Michel Cadot
Messages: 65134
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You don't have or need to manage space in your undo tablespace. Oracle do it for you.
It will release space when it needs it.
Undo tablespace is ALWAYS almost or completly full after a while, this is the normal behaviour.

Previous Topic: faq
Next Topic: can't offline
Goto Forum:

Current Time: Wed Aug 16 12:20:06 CDT 2017

Total time taken to generate the page: 0.21764 seconds