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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Why increase in UNDO after truncate?

Re: Why increase in UNDO after truncate?

From: Christo Kutrovsky <kutrovsky.oracle_at_gmail.com>
Date: Tue, 17 Oct 2006 10:36:13 -0400
Message-ID: <52a152eb0610170736h23eb2f40j45fabeac98eed674@mail.gmail.com>


Space allocation is still transactional, so that could be a contributor.

Try "truncate ... reuse storage" this will not de-allocate the extents, but still lower the high water mark.

-- 
Christo Kutrovsky
Senior Database/System Administrator
The Pythian Group - www.pythian.com
I blog at http://www.pythian.com/blogs/


On 10/16/06, J. Dex <cemail_219_at_hotmail.com> wrote:

> This is probably a stupid question but I have a 9207 database. In order to
> do a refresh, I truncate all the tables, disable sequences, foreign keys,
> etc. Since I truncate all the tables, etc., I don't understand why when I
> run an import it dramatically increases the size of the UNDO tablespace?
> What is it increasing UNDO? Is there any way around it?
>
> _________________________________________________________________
> Try Search Survival Kits: Fix up your home and better handle your cash with
> Live Search!
> http://imagine-windowslive.com/search/kits/default.aspx?kit=improve&locale=en-US&source=hmtagline
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- Christo Kutrovsky Senior Database/System Administrator The Pythian Group - www.pythian.com I blog at http://www.pythian.com/blogs/ -- http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 17 2006 - 09:36:13 CDT

Original text of this message

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