Re: Why increase in UNDO after truncate?
- From: "Christo Kutrovsky" <kutrovsky.oracle@xxxxxxxxx>
- To: cemail_219@xxxxxxxxxxx
- Date: Tue, 17 Oct 2006 10:36:13 -0400
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@xxxxxxxxxxx> 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
--
//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/
--
//www.freelists.org/webpage/oracle-l
Other related posts:
