I've been given an oracle DMP file that was created on a solaris system which I need to restore to a windows system.
I've created the DB with the correct blocksize, but when I try and do the restore it complains that it can't create the folders.
I've created the folder in Windows and in my imp command i've specified the directory, but it still fails.
How can I resolve this?
Here is the full error message
IMP-00003: ORACLE error 1119 encountered ORA-01119: error in creating database file '/home/oradata/d_test01/tools01.dbf' ORA-27040: file create error, unable to create file
What do i need to specify in the restore command to change the restore location. As I said previously the backup was created on a solaris based system and I have trying to restore it on Windows
All i've been given is the dmp file. It was created by a consultant who no longer does work for us.
Hope someone can help.