OraFAQ Forum: Server Utilities » IMPORT(Impdp) multiple dump files

Home » RDBMS Server » Server Utilities » IMPORT(Impdp) multiple dump files (Linux , oracle 11g)

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

IMPORT(Impdp) multiple dump files [message #562601]

Thu, 02 August 2012 13:09

chandu208
Messages: 17
Registered: July 2012

Junior Member

i have more than 100 dumpfiles to import into my oracle 11g database. i know how to import(impdp) for same named dumps but here all the dumpfile names are totally different(ex: aa.dmp,bb.dmp,...........)

can anyone please send me the syntax or solution to do ???

Report message to a moderator

Re: IMPORT(Impdp) multiple dump files [message #562604 is a reply to message #562601]

Thu, 02 August 2012 13:13

Michel Cadot
Messages: 68765
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Here's a starter:

for f in `ls *.dmp`
do
  impdp user/psw dumpfile=$f full=y
done

Regards
Michel

[Updated on: Thu, 02 August 2012 13:13]

Report message to a moderator

Re: IMPORT(Impdp) multiple dump files [message #562605 is a reply to message #562601]

Thu, 02 August 2012 13:14

chandu208
Messages: 17
Registered: July 2012

Junior Member

after searching came to know we can give like dumpfile=(dumpfile1.dmp,dumpfile2.dmp,............300 dumps) looking for any other altenative because i dont wanna include all 300 dumps) if not i can go with same command above

Report message to a moderator

Re: IMPORT(Impdp) multiple dump files [message #562613 is a reply to message #562605]

Thu, 02 August 2012 13:28

Michel Cadot
Messages: 68765
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Ah! you meant ONE export gives 300 files NOT 300 exports with 1 file.
Something like:

echo 'dumpfile=(' > liste.txt
for f in `ls *.dmp`
do
  echo "$f," >> liste.txt
done
sed -e 's/,$/)/' liste.txt >parfile
impdp user/psw full=y parfile=parfile

Regards
Michel

Report message to a moderator

Previous Topic:	10g-32bit,developer 6i
Next Topic:	count of data in sql loader

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Aug 05 00:09:44 CDT 2025