Were you doing import to an existing table (with indexes)?
________________________________
From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Michael Ebert
Sent: Thursday, November 17, 2005 11:19 AM
To: belvdr@yahoo.com; oracle-l@freelists.org
Subject: Re: Making sure all objects moved
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@yahoo.com>
Please respond to belvdr@yahoo.com
Sent by: oracle-l-bounce@freelists.org
17-11-05 15:56
To
oracle-l@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
_____________________________________________________________________________________________________________
This electronic transmission and any attached files are intended solely for the person or entity to which they are addressed and may contain
information that is privileged, confidential or otherwise protected from disclosure. Any review, retransmission, dissemination or other use,
including taking any action concerning this information by anyone other than the named recipient, is strictly prohibited. If you are not the
intended recipient or have received this communication in error, please immediately notify the sender and destroy this communication.
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 17 2005 - 12:37:03 CST
