Home » RDBMS Server » Server Administration » how to import .dmp file
how to import .dmp file [message #137386] Thu, 15 September 2005 01:13 Go to next message
suchita24
Messages: 9
Registered: September 2005
Location: mumbai
Junior Member
hi
i want to import my .dmp (data) file in oracle8i so how i do this
Re: how to import .dmp file [message #137404 is a reply to message #137386] Thu, 15 September 2005 02:20 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member


Hi,

How about reading this link

regards,
tarun
Re: how to import .dmp file [message #137473 is a reply to message #137386] Thu, 15 September 2005 06:06 Go to previous message
Jay Munshi
Messages: 30
Registered: July 2004
Member
any of these two:

a)imp userid=user/password file=import.dmp log=import.log statistics=none feedback=10000 buffer=409680

b)imp userid=system/manager(or whatever password) file=import.dmp log=import.log statistics=none feedback=10000 buffer=409680 fromuser=exporting_user touser=user_to_where_u_wanna_import


further more if you wanna see help for the imp utitlity type
"imp help=y" on the command prompt.

if you wanna know about exportding databases check my paper on the same at http://jaydba.tripod.com/id60.html
Regards,
Jay
http://jaydba.tripod.com

[Updated on: Thu, 15 September 2005 06:09]

Report message to a moderator

Previous Topic: Solaris 9, 10g how to provide more enqueues'
Next Topic: No Listner (how to create listner servive on Unix box)
Goto Forum:
  


Current Time: Fri Jan 10 10:25:18 CST 2025