Re: Making sure all objects moved
- From: Michael Ebert <mebert@xxxxxxxxxxx>
- To: belvdr@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Thu, 17 Nov 2005 18:19:25 +0100
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
Other related posts:
