Re: Undo Tablespace Question

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Tue, 22 Nov 2005 20:22:40 +0100
Message-ID: <43837001$0$2144$ba620e4c@news.skynet.be>

"Syltrem" <syltremzulu_at_videotron.ca> wrote in message news:11o6o6oisf80p2e_at_corp.supernews.com...
>
> <amerar_at_iwc.net> wrote in message
> news:1132673497.377957.46180_at_g43g2000cwa.googlegroups.com...
>> Diskspace is being used up rapidly. Guess I can drop the undo
>> tablespace and rebuild it........
>>
>
> If you have a transaction that uses too much undo space, you must look
> into it and correct it.
> It's possible that it is entirely valid though, in which case you should
> set the undo tablespace to a large enough value to handle it, and leave it
> that way.
>
> Syltrem
>
>

If you need a large amount of undo space for your transaction to finish (or rollback) consistently, nothing can be done to "correct it". At this point the only thing you can do is to allocate more diskspace for your undo tablespace.

Matthias Received on Tue Nov 22 2005 - 13:22:40 CST