Home » RDBMS Server » Server Utilities » Impdp with multiple dump file directories (oracle10g)
Impdp with multiple dump file directories [message #403531] Sat, 16 May 2009 09:03 Go to next message
shrinika
Messages: 266
Registered: April 2008
Senior Member
Hello,

I am exporting the schema and place the dump file in three different directories...
At the end,i wanted to load the dump files into another database.

Here is the export parfile content. Export is successfully completed.

userid=system/password@orcl 
logfile=schemaexp_split.log 
directory=(dump1,dump2,dump3)
dump1dumpfile=dump1:schemaexp_%U.dmp,dump2:schemaexp_%U.dmp,dump3:schemaexp_%U.dmp 
schemas=scott
include=table


How can i import these dump files into target server?.
I am using the below parfile content..

userid=system/password@ordb 
logfile=schemaimp_split.log 
directory=dumplocation
dumpfile=dump1:schemaexp_%U.dmp,dump2:schemaexp_%U.dmp,dump3:schemaexp_%U.dmp 
table_exists_action=replace
remap_tablespace=res:users 
exclude=grant


Here is the error message when i run the imp parfile.

C:\impexpdp>impdp parfile=splitdumpimp3.par

Import: Release 10.1.0.2.0 - Production on Saturday, 16 May, 2009 9:53

Copyright (c) 2003, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc
tion
With the Partitioning, OLAP and Data Mining options
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-39087: directory name DUMP1 is invalid



C:\impexpdp>



It says, DUMP1 is invalid. But export wrote the dump file on this directory successfully....

Any help is appreicated...
Re: Impdp with multiple dump file directories [message #403532 is a reply to message #403531] Sat, 16 May 2009 09:16 Go to previous messageGo to next message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
This is a shoot from the hip response where I have not had my 1st cup of coffee this morning.

A similar error can occur where version differences exist between exp & imp; typically exp is higher version than imp.

You decided we did not need to know Oracle versions involved in your situation.
Re: Impdp with multiple dump file directories [message #403559 is a reply to message #403532] Sat, 16 May 2009 19:57 Go to previous messageGo to next message
shrinika
Messages: 266
Registered: April 2008
Senior Member
Hello, i am using oracle10g R1. The utility i am using here is expdp/impdp. Hope i answered your questions.
Re: Impdp with multiple dump file directories [message #403604 is a reply to message #403559] Sun, 17 May 2009 08:26 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>It says, DUMP1 is invalid. But export wrote the dump file on this directory successfully....

Are you sure?
I do not have 10gR1 around, so I cannot test it.
Tested with 10gR2 and 11g.
directory parameter cannot take multiple values.
Either you are not telling us the whole story
or
My eyes have deceived me and misunderstood your post.

oracle#cat par.par
directory=(dir1,dir2) 
dumpfile=dir1:schemaexp_%U.dmp,dir2:schemaexp_%U.dmp  

oracle#expdp dbadmin/xxx parfile=par.par
LRM-00112: multiple values not allowed for parameter 'directory'
LRM-00113: error when processing file 'par.par'

Also,
values specified in DUMPFILE will override DIRECTORY value.
http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/dp_export.htm#sthref96


Look into logfiles for expdp.
You must see something like this
Dump file set for SCOTT.SYS_EXPORT_SCHEMA_01 is:
  /export/home/oracle/a10/schemaexp_01.dmp

Verify it.Post the log for expdp.
Re: Impdp with multiple dump file directories [message #403605 is a reply to message #403559] Sun, 17 May 2009 08:33 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Meanwhile,
What is the OS?
Are you using environment variable DATA_PUMP_DIR?
Re: Impdp with multiple dump file directories [message #403618 is a reply to message #403605] Sun, 17 May 2009 10:47 Go to previous message
shrinika
Messages: 266
Registered: April 2008
Senior Member
Mahesh, There was a mistake in my first post in this thread. My expdp parfile content was wrong...
But anyhow, i did not have any issues on expdp. I have concern only on impdp.
I am testing this in my local machine and i am using Windows XP.

Here is the parfile content for expdp.

userid=system/password@orcl 
logfile=schemaexp_split.log 
directory=dumplocation
dumpfile=dump1:schemaexp_%U.dmp,dump2:schemaexp_%U.dmp,dump3:schemaexp_%U.dmp 
schemas=scott
include=table


Here is the parfile content for impdp.

userid=system/password@ordb 
logfile=schemaimp_split.log 
directory=dumplocation
dumpfile=dump1:schemaexp_%U.dmp,dump2:schemaexp_%U.dmp,dump3:schemaexp_%U.dmp
table_exists_action=replace


I was using oracle10gR1 and expdp run successfully and placed the dump file in three different location.
When i use impdp, it was not reading dumpfile from three different location... I am not sure that
i have made some mistake or there was a bug in oracle10gR1.

Now i upgraded to Oracle10gR2. Now import is successfully completetd and it read the dump file from three different location.
When i use Oracle10gR1, the same impdp parfile content did not work.

Here is the version i am using now.
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0      Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production


Anyhow, thank you for your time here and appreciate your help.

Once again Thank you!!!.


Previous Topic: Importing dmp file - first time
Next Topic: How to loading tab separated,tab delimited datafile with SQLLDR
Goto Forum:
  


Current Time: Wed Dec 07 20:28:50 CST 2016

Total time taken to generate the page: 0.17148 seconds