OraFAQ Forum: Server Utilities » Impdp with multiple dump file directories

Home » RDBMS Server » Server Utilities » Impdp with multiple dump file directories (oracle10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Impdp with multiple dump file directories [message #403531]

Sat, 16 May 2009 09:03

shrinika
Messages: 306
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...

Report message to a moderator

Re: Impdp with multiple dump file directories [message #403532 is a reply to message #403531]

Sat, 16 May 2009 09:16

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: Impdp with multiple dump file directories [message #403559 is a reply to message #403532]

Sat, 16 May 2009 19:57

shrinika
Messages: 306
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.

Report message to a moderator

Re: Impdp with multiple dump file directories [message #403604 is a reply to message #403559]

Sun, 17 May 2009 08:26

Mahesh Rajendran
Messages: 10707
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.

Report message to a moderator

Re: Impdp with multiple dump file directories [message #403605 is a reply to message #403559]

Sun, 17 May 2009 08:33

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Meanwhile,
What is the OS?
Are you using environment variable DATA_PUMP_DIR?

Report message to a moderator

Re: Impdp with multiple dump file directories [message #403618 is a reply to message #403605]

Sun, 17 May 2009 10:47

shrinika
Messages: 306
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!!!.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 23:47:53 CDT 2024