Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.server -> Re: Data Pump slower than equivalent Export ?!?

Re: Data Pump slower than equivalent Export ?!?

From: Noons <>
Date: Sun, 18 Sep 2005 00:14:11 +1000
Message-ID: <432c24b3$0$26365$>

Ronald Rood apparently said,on my timestamp of 17/09/2005 8:44 PM:

>>Today, I did some tests with Data Pump on AIX 5.2 (Oracle First 
>>impressions ? Not so good. Lots of ORA-00600 errors during a full export, or 
>>an export of only metadata. I opened a TAR and Oracle is investigating this. 
>>And yes, I have read the docs ;-) Other issue : to be able to perform a full 
>>export, a user does not only need EXP_FULL_DATABASE, but also CREATE TABLE. 
>>Second issue : expdp can't overwrite already existing dump files with the 
>>same name ...
>>The "good old" exp works fine though.

> I also noticed some problems during expdp ('illegal use of LONG datatype' for
> example ... That's why I started with impdp directly from the source database
> over a network link. Quite powerfull, if it works... It is sensitive for NLS
> settings and I did get data corruption in some cases that where tracked back
> to be caused by an insert into a table from a remote table. It looks like
> impdp first creates the table and does the insert afterwards.
> In the end I also used exp/imp to do the job but I will sure check for
> improvements in release 2.
> possible improvements are
> 1) better compatibility check for NLS settings
> 2) get rid of the 'invalid use of LONG datatype in expdp
> 3) get rid of the datacorruption - database link issue
> 4) parallelism after the data move (procs, indexes etc)
> 5) a summary of errors encountered in the end of the log
> 6) keep the filesize limit when adding extra files to expdp

Far out! I'm soooooo glad we stayed away from 10.1.... No wonder so few people use this thing for critical dbs!

Nuno Souto
in sunny Sydney, Australia
Received on Sat Sep 17 2005 - 09:14:11 CDT

Original text of this message