Restore an oracle dmp file

importoracle

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?

Thanks

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.

Best Answer

This is a full database import which also includes tablespace definitions. Find out from the original Solaris database what are all the target tablespace names and sizes. Pre-create the tablespaces manually using the datafile paths of your choice (C:\data\) before performing the import. You will see IMP-00015: following statement failed because the object already exists: your tablespace which you can ignore.

Related Solutions

Windows – Import Oracle full dump file to fresh Oracle installation

If you are using the old imp method the users and tablespaces must be created first. This includes grants, database links and any advanced queues you may be using. A sample script could look like this in Windows imp a_DBA_user/apassword LOG =C:\dump\logs\import.log file =user01.dmp fromuser=user_name touser=user_name

The newer datapump method works wonderfully. You don't need to create the user but I would create any custom tablespaces you may have on the original.

A sample data pump call requires you to create a database link to the original database and a directory. This creates a directory

CREATE OR REPLACE DIRECTORY 
DATA_PUMP_DIR AS 
'C:\app\Oracle\product\11.2.0\dbhome_1\rdbms\log\';


GRANT READ, WRITE ON DIRECTORY DATA_PUMP_DIR TO EXP_FULL_DATABASE;

GRANT READ, WRITE ON DIRECTORY DATA_PUMP_DIR TO auser;

GRANT READ, WRITE ON DIRECTORY DATA_PUMP_DIR TO IMP_FULL_DATABASE;

In your script to import set these variables NLS_LANG

ORACLE_SID= your database name

impdp a_user_who_exists/your database name directory=DATA_PUMP_DIR network_link=original database name schemas= user1,user2 LOGFILE=DataPump.log TABLE_EXISTS_ACTION=REPLACE

ORA-12899: importing a .dmp file + character set conversion

One solution is to have both databases using the same character set. Considering your destination is a free XE version why not do a new install? Just make sure you use EL8MSWIN1253 character set and the same UTF version.

Best Answer

Related Solutions

Windows – Import Oracle full dump file to fresh Oracle installation

ORA-12899: importing a .dmp file + character set conversion

Related Question