Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Data Pump DataFile Remapping does not work

Jim ThompsonApr 17 2012 — edited Apr 19 2012

Hi,

I have done a full data pump export of my database and I am now trying to do a full import into a new database on another server but with a remap of my datafiles to go to a new directory ( which already exists on the new server )

However the import seems to be ignoring the remap and is trying to create the datafiles as per the old directrory structure

For example my import par file states

full=y
remap_datafile=E:\oracle\product\10.2.0\oradata\LIMSLIVE\STATSPACK01.DBF:E:\Databases\LIMSTEST\data_index_files\STATSPACK01.DBF
remap_datafile=E:\oracle\product\10.2.0\oradata\LIMSLIVE\COMPUWARE.DBF:E:\Databases\LIMSTEST\data_index_files\COMPUWARE.DBF
remap_datafile=E:\oracle\product\10.2.0\oradata\LIMSLIVE\LVSI1LIMSLIVE.DBF:E:\Databases\LIMSTEST\data_index_files\LVSI1LIMSTEST.DBF
remap_datafile=E:\oracle\product\10.2.0\oradata\LIMSLIVE\LVSSPACE01.DBF:E:\Databases\LIMSTEST\data_index_files\LVSSPACE01.DBF
remap_datafile=E:\oracle\product\10.2.0\oradata\LIMSLIVE\LVSSPACE02.DBF:E:\Databases\LIMSTEST\data_index_files\LVSSPACE02.DBF
remap_datafile=E:\oracle\product\10.2.0\oradata\LIMSLIVE\LVSSPACE03.DBF:E:\Databases\LIMSTEST\data_index_files\LVSSPACE03.DBF
remap_datafile=E:\oracle\product\10.2.0\oradata\LIMSLIVE\LVSSPACE04.DBF:E:\Databases\LIMSTEST\data_index_files\LVSSPACE04.DBF
remap_datafile=E:\oracle\product\10.2.0\oradata\LIMSLIVE\LVSSPACE05.DBF:E:\Databases\LIMSTEST\data_index_files\LVSSPACE05.DBF
remap_datafile=E:\oracle\product\10.2.0\oradata\LIMSLIVE\LVSSPACE06.DBF:E:\Databases\LIMSTEST\data_index_files\LVSSPACE06.DBF
remap_datafile=E:\oracle\product\10.2.0\oradata\LIMSLIVE\LVSSPACE07.DBF:E:\Databases\LIMSTEST\data_index_files\LVSSPACE07.DBF
remap_datafile=E:\oracle\product\10.2.0\oradata\LIMSLIVE\LVSSPACE08.DBF:E:\Databases\LIMSTEST\data_index_files\LVSSPACE08.DBF
remap_datafile=E:\oracle\product\10.2.0\oradata\LIMSLIVE\LVSSPACE09.DBF:E:\Databases\LIMSTEST\data_index_files\LVSSPACE09.DBF
remap_datafile=E:\oracle\product\10.2.0\oradata\LIMSLIVE\LVSSPACE10.DBF:E:\Databases\LIMSTEST\data_index_files\LVSSPACE10.DBF
remap_datafile=E:\oracle\product\10.2.0\oradata\LIMSLIVE\LVSSPACE11.DBF:E:\Databases\LIMSTEST\data_index_files\LVSSPACE11.DBF
remap_datafile=E:\oracle\product\10.2.0\oradata\LIMSLIVE\LVSSPACE12.DBF:E:\Databases\LIMSTEST\data_index_files\LVSSPACE12.DBF
remap_datafile=E:\oracle\product\10.2.0\oradata\LIMSLIVE\TOOLS01.DBF:E:\Databases\LIMSTEST\data_index_files\TOOLS01.DBF
remap_datafile=E:\oracle\product\10.2.0\oradata\LIMSLIVE\USERS01.DBF:E:\Databases\LIMSTEST\data_index_files\USERS01.DBF
metrics=y
directory=dump_dir
table_exists_action=append
dumpfile=dump_dir:exp_full_LIMSLIVE.dmp
logfile=log_dir:imp_full_LIMSTEST.log
job_name=imp_full_LIMSTEST

however my import log shows errors with each tablespace creation

ORA-01119: error in creating database file 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\LIMSLIVE\LVSSPACE01.DBF'
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.
Failing sql is:
CREATE TABLESPACE "LVSSPACE" DATAFILE 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\LIMSLIVE\LVSSPACE01.DBF' SIZE 2621440000,'E:\ORACLE\PRODUCT\10.2.0\ORADATA\LIMSLIVE\LVSSPACE02.DBF' SIZE 2621440000

you can see it is using the original path for the datafile and not the new remapped path

any idea of what is goinging on ?
Jim