Home » RDBMS Server » Server Utilities » imp from .rar (10.2.0.1,windows 2003)
imp from .rar [message #331256] Wed, 02 July 2008 15:20 Go to next message
sant_new
Messages: 165
Registered: June 2008
Senior Member
Hi all,

I have a 2GB exp dmp(.rar file) and when I unzip the file it splits into 6 dmp files each of 1.5GB size. I need to import this data into a new database and trying to find out if there is a way I can use the .rar file in the imp command
instead of unzipping all the dmp files.

Thanks for any help.

Report message to a moderator

Re: imp from .rar [message #331258 is a reply to message #331256] Wed, 02 July 2008 15:26 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>is a way I can use the .rar file in the imp command instead of unzipping all the dmp files.
NO!

Report message to a moderator

Re: imp from .rar [message #331259 is a reply to message #331256] Wed, 02 July 2008 15:29 Go to previous messageGo to next message
sant_new
Messages: 165
Registered: June 2008
Senior Member
Ok thanks. Is there an option I can mention all the dumps in one imp command and import all the data at once?

Not sure if the below command is right..

imp ordi/pwd@ord file=exp1.dmp,exp2.dmp,exp3.dmp log=exp.log buffer=4000000 full=y


Thanks for the help

Report message to a moderator

Re: imp from .rar [message #331265 is a reply to message #331259] Wed, 02 July 2008 15:51 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As usually, when everything else fails, read the documentation. Pay attention to FILE export/import parameter.

Report message to a moderator

Re: imp from .rar [message #331266 is a reply to message #331256] Wed, 02 July 2008 16:00 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Ready, Fire, AIM!
A potential problem with using IMP is/are constraint issues & the order tables get loaded (or not).
You can not load child table until after parent table is loaded.

Report message to a moderator

Re: imp from .rar [message #331267 is a reply to message #331256] Wed, 02 July 2008 16:00 Go to previous messageGo to next message
sant_new
Messages: 165
Registered: June 2008
Senior Member
But, I do not see how to import multiple files in the documentations though. THanks

Report message to a moderator

Re: imp from .rar [message #331268 is a reply to message #331267] Wed, 02 July 2008 16:05 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
So which part here from the link that Littlefoot provided did you miss ??

Report message to a moderator

Previous Topic: SQL*Loader-704: Internal error: ... ORA-12560: TNS:protocol adapter error
Next Topic: export tables
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 24 11:05:11 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.