Home » RDBMS Server » Server Administration » Undo space
Undo space [message #238680] Fri, 18 May 2007 23:56 Go to next message
Messages: 259
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: 63929
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 Oct 26 22:50:30 CDT 2016

Total time taken to generate the page: 0.05236 seconds