expdp filesize but impdp error (Data Pump)

From: aman.oracle.dba <aman.oracle.dba_at_gmail.com>
Date: Sun, 10 Aug 2008 02:54:13 -0700 (PDT)
Message-ID: <cb0ffea7-5d4d-4aba-aad1-cb7d3f286229@v13g2000pro.googlegroups.com>

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 - 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 - 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, Received on Sun Aug 10 2008 - 04:54:13 CDT

Original text of this message