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/
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
-- 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