Re: Making sure all objects moved

From: Michael Ebert <mebert_at_amadeus.com>
Date: Thu, 17 Nov 2005 18:19:25 +0100
Message-ID: <OFCFCE4F83.7B197C54-ONC12570BC.005E47F3-C12570BC.005F2991@amadeus.com>

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_at_yahoo.com>
Please respond to belvdr_at_yahoo.com
Sent by: oracle-l-bounce_at_freelists.org
17-11-05 15:56

To
oracle-l_at_freelists.org
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

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Nov 17 2005 - 12:23:03 CST