Home » RDBMS Server » Server Utilities » IMPORT
IMPORT [message #190311] Wed, 30 August 2006 02:57 Go to next message
Messages: 10
Registered: August 2005
Location: india
Junior Member
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
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
Messages: 52
Registered: August 2006
Location: India


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.


Mohan Reddy G
Previous Topic: DATA PUMP using up UNDO! (and temp)
Next Topic: when to use SQL loader
Goto Forum:

Current Time: Mon Aug 21 22:42:15 CDT 2017

Total time taken to generate the page: 0.15594 seconds