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