Re: expdp filesize but impdp error (Data Pump)

On Sun, 10 Aug 2008 02:54:13 -0700, aman.oracle.dba wrote:

> 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
>
> Copyright (c) 2003, 2005, Oracle. All rights reserved.
>
> 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,

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

-- 
http://mgogala.freehostia.com