RE: Making sure all objects moved
- From: "Thomas Biju" <BThomas@xxxxxxxxxx>
- To: <mebert@xxxxxxxxxxx>, <belvdr@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 17 Nov 2005 11:33:39 -0600
Were you doing import to an existing table (with indexes)?
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Michael Ebert
Sent: Thursday, November 17, 2005 11:19 AM
To: belvdr@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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@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
_____________________________________________________________________________________________________________
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.
Other related posts:
