expdp filesize but impdp error (Data Pump)

aman.oracle.dba

unread,

Aug 10, 2008, 5:54:13 AM8/10/08

to

Hi All,

In oracle 9i we do exp with filesize, so that if there is less space
available when doing imp then we can import in parts.
But when I tried same thing in oracle 10g with data pump, I got error.
I use following command:
***************************************************
$ expdp dumpfile=hr%U.dmp filesize=3G directory=dir1 schemas=hr
logfile=log1hr.log
**************************************************
This created 8 files (hr01.dmp, hr02.dmp ... hr08.dmp)
***************************************************
$ impdp dumpfile=hr01.dmp directory=dir1 remap_schema=hr:hr2
logfile=log2hr.log

Import: Release 10.2.0.1.0 - Production on Sunday, 10 August, 2008
15:15:20

Username: / as sysdba

Connected to: Oracle Database 10g Enterprise Edition Release
10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
ORA-39002: invalid operation
ORA-39059: dump file set is incomplete
***************************************************
I don't have much space on system where I am import this file... I can
use only 3GB of space.

Can someone please help to understand how to use it....

Thanks,

Mladen Gogala

unread,

Aug 10, 2008, 7:18:19 AM8/10/08

to

Try using the NETWORK_LINK parameter. It requires no dumpfile at all.

--
http://mgogala.freehostia.com

aman.oracle.dba

unread,

Aug 10, 2008, 8:46:22 AM8/10/08

to

> --http://mgogala.freehostia.com- Hide quoted text -
>
> - Show quoted text -

Actually these both servers are not on same network.. so it can't be
done.
Is there anything which can be done.

Please suggest.

Thanks,

sybr...@hccnet.nl

unread,

Aug 10, 2008, 9:10:25 AM8/10/08

to

On Sun, 10 Aug 2008 05:46:22 -0700 (PDT), "aman.oracle.dba"
<aman.or...@gmail.com> wrote:

>Is there anything which can be done.
>
>Please suggest.
>
>Thanks,

The obvious answer of course is doing the one thing you refuse to do:
reading the documentation.
I have read the documentation on your behalf for free, and noticed all
dumpfiles need to be present at import, or you will get this error.

--
Sybrand Bakker
Senior Oracle DBA

aman.oracle.dba

unread,

Aug 10, 2008, 9:56:33 AM8/10/08

to

On Aug 10, 6:10 pm, sybra...@hccnet.nl wrote:
> On Sun, 10 Aug 2008 05:46:22 -0700 (PDT), "aman.oracle.dba"
>

> <aman.oracle....@gmail.com> wrote:
> >Is there anything which can be done.
>
> >Please suggest.
>
> >Thanks,
>
> The obvious answer of course is doing the one thing you refuse to do:
> reading the documentation.
> I have read the documentation on your behalf for free, and noticed all
> dumpfiles need to be present at import, or you will get this error.
>
> --
> Sybrand Bakker
> Senior Oracle DBA

Thanks Sybrand.

That is what I read it. But I was confuse because in Oracle 9i we can
do import with one file at a time.
But is that means if we have less space on the server where we are
going to imp then we should go for imp rather then data pump.

Regards,
Steve

Mladen Gogala

unread,

Aug 10, 2008, 11:52:47 AM8/10/08

to

On Sun, 10 Aug 2008 06:56:33 -0700, aman.oracle.dba wrote:

> That is what I read it. But I was confuse because in Oracle 9i we can do
> import with one file at a time.

That is the problem with 9i. It cannot process files in parallel. The 10g
version, impdp can do that. Of course, you need all the files present
before you start but you gain speed. Of course, there is nothing
preventing you from doing the old, 9i style export/import but in that
case, you must kiss the speed goodbye.

--
http://mgogala.freehostia.com