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>
$ 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
I don't have much space on system where I am import this file... I can use only 3GB of space.
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 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, Received on Sun Aug 10 2008 - 04:54:13 CDT