| Undo space [message #238680] |
Fri, 18 May 2007 23:56  |
gajini
Messages: 262
Registered: January 2006
|
Senior Member |
|
|
Hi,
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.
Thanks..
|
|
|
|
| Re: Undo space [message #238686 is a reply to message #238680] |
Sat, 19 May 2007 00:38  |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
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.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
