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
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.
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
Previous Topic: exporting big table
Next Topic: Loading 3,500,000 records
Goto Forum:
  


Current Time: Fri Dec 09 05:36:16 CST 2016

Total time taken to generate the page: 0.12773 seconds