Home » RDBMS Server » Server Utilities » IMPORT
IMPORT [message #190311] Wed, 30 August 2006 02:57 Go to next message
raza_oca
Messages: 10
Registered: August 2005
Location: india
Junior Member
HI,
Can any one explan me the syntax to import a dmp file to oracle. i hadn't ryied it before. thank you

Report message to a moderator

Re: IMPORT [message #190354 is a reply to message #190311] Wed, 30 August 2006 06:00 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Here are the parameters Import Parameters. You could also issue imp -help at the command prompt for help.

Report message to a moderator

Re: IMPORT [message #190677 is a reply to message #190311] Thu, 31 August 2006 12:50 Go to previous message
goudelly
Messages: 52
Registered: August 2006
Location: India
Member
Hi,

For ex you have a dump file of scott user then follow below code and before this you have scott user and with out any schema objects in it.. or else it will generate the errors..

c:\>imp userid=system/manager@orcl fromuser=scott touser=scott file=c:\abcd.dmp log=c:\abcd.log


the above code will import the scott user .dmp file in to your oracle databse.

thanks,

Mohan Reddy G

Report message to a moderator

Previous Topic: exporting big table
Next Topic: Loading 3,500,000 records
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Dec 26 00:25:26 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.