How to restore Unix Oracle Dmp file

April 20, 2009 at 10:41:14
Specs: Windows 2003 Enterprise Edition
Please help me to restore a Oracle Dump file that is generated from a Unix sever onto a Oracle installed on Windows Server 2003? Actually I dont have much knowledge on Unix, so please let me know the detailed steps or the exact tool that can help me.

Thanks in advance.

See More: How to restore Unix Oracle Dmp file

Report •

June 4, 2009 at 12:38:09
imp username/password@SID file=C:/FILENAME.dmp fromuser=XXXXX touser=XXXXX ignore=y log=C:/import.log

if you start with that command, you will probably see a message in your console that says the records were exported by SOMEUSER and not by you. Use this value in the fromuser field.

SID is the oracle SID, which should be in the tnsnames.ora file

Report •
Related Solutions

Ask Question