Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Undo Tablespace Question

Re: Undo Tablespace Question

From: Syltrem <syltremzulu_at_videotron.ca>
Date: Tue, 22 Nov 2005 13:18:12 -0500
Message-ID: <11o6o6oisf80p2e@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 Received on Tue Nov 22 2005 - 12:18:12 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US