Re: How to shrink undo tablespace

On Tue, 06 Dec 2005 07:42:41 -0800, Daniel Fink wrote:

> You can create a new undo tablespace and switch to it. It is best to do
> this at a time of very low activity as this can lead to ORA-01555
> errors for currently running queries.

Of course, the fact that undo tablespace auto-extended to 16GB means that something used up all that space. So, by shrinking the tablespace, he is more then likely to discover what exactly was it. This is so called "auditing by error": you mess up and find out who will scream. As you are very well aware of, disk space is the final frontier. By shrinking the undo tablespace he will boldly mess up what many have used before.

-- 
http://www.mgogala.com