28 February 2014

How to restore .dmp oracle file by using import

I take it as a challenge for myself when a friend in workplace ask for a help about how to restore a dmp file to a local machine.

Honestly, i have never done it before. so I went to google activity and found this related article. Thanks to Frenda on (http://frenda.wordpress.com/2013/01/05/importing-oracle-dmp-file-using-cmd/)

This was the summary that i have done on local machine
1. create user on oracle db (login using system)
2. setting connection on tns file
3. open command prompt | entry 'IMP'
4. follow the instructions. (image attached)

5. database are imported to my local machine

that's it and it works


No comments:

Post a Comment

Twiit.. Twiit... Gulp