I think Tom Kytes answer in this respect is wrong. Just yesterday I did an import into a 9.2.0.5 database with commit=n, and it failed with an "cannot extend UNDOTBS1 by 8" trying to import a 1.5M row partition. UNDOTBS1 had 1GB of space. It was a test database with very little other activity. I changed to commit=y (and also added two datafiles to UNDOTBS1 for a total of 5GB for good measure) and the import worked... Dr. Michael Ebert DB2 & Oracle Database Administrator aMaDEUS Data Processing Erding / Munich, Germany Thomas Fox <belvdr@xxxxxxxxx> Please respond to belvdr@xxxxxxxxx Sent by: oracle-l-bounce@xxxxxxxxxxxxx 17-11-05 15:56 To oracle-l@xxxxxxxxxxxxx cc Subject Re: Making sure all objects moved In regards to commit=y, there is a discussion regarding the amount of undo that is needed. Tom Kyte gave one answer, while the Oracle 9i docs gave a different answer. http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:230214032357 My question to Tom, and his reply with an example, is near the bottom. Just search for "Tom Fox from Cinti, OH". Tom