Re: expdp filesize but impdp error (Data Pump)

On Aug 10, 4:18 pm, Mladen Gogala <mgog..._at_yahoo.com> wrote:
> 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- 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, Received on Sun Aug 10 2008 - 07:46:22 CDT