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: 64730
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: Sat Apr 29 02:27:08 CDT 2017

Total time taken to generate the page: 0.10772 seconds