Home » RDBMS Server » Server Utilities » IMPORT(Impdp) multiple dump files (Linux , oracle 11g)
IMPORT(Impdp) multiple dump files [message #562601] Thu, 02 August 2012 13:09 Go to next message
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 ???
Re: IMPORT(Impdp) multiple dump files [message #562604 is a reply to message #562601] Thu, 02 August 2012 13:13 Go to previous messageGo to next message
Michel Cadot
Messages: 67370
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
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
Re: IMPORT(Impdp) multiple dump files [message #562613 is a reply to message #562605] Thu, 02 August 2012 13:28 Go to previous message
Michel Cadot
Messages: 67370
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: 10g-32bit,developer 6i
Next Topic: count of data in sql loader
Goto Forum:
  


Current Time: Sun Sep 27 13:10:57 CDT 2020