Data Pump Woes - REMAP_DATAFILE
572202Apr 12 2007 — edited Apr 13 2007I have tried to use both the Enterprise Manager and the impdp and cannot get the REMAP_DATAFILE to work. The impdp barks at the syntax of my string. I have tried several permutations of the REMAP_DATAFILE option. Single quotes, no quotes, dbl quotes, one REMAP_DATAFILE delimited by commas....etc
I have included the content of my par file here.
Any clues ... please.
Full=Y
directory=dpump_dir
Logfile=implog55.log
dumpfile=dpu.dmp
sqlfile=dpu_sql.sql
REMAP_DATAFILE='E:\ORACLE\PRODUCT\10.1.0\DPUDEV\ORADATA\SDE.DBF':'g:\oracle\clay2\sde.dbf'
REMAP_DATAFILE='E:\ORACLE\PRODUCT\10.1.0\DPUDEV\ORADATA\DPU_DATA.DBF':'g:\oracle\clay2\DPU_DATA.DBF'
REMAP_DATAFILE='E:\ORACLE\PRODUCT\10.1.0\DPUDEV\ORA_INDX\DPU_INDEX.DBF':'g:\oracle\clay2\DPU_INDEX.DBF'
REMAP_DATAFILE='E:\ORACLE\PRODUCT\10.1.0\DPUDEV\ORA_INDX\DPU_SINDEX.DBF':'g:\oracle\clay2\DPU_SINDEX.DBF'
REMAP_DATAFILE='E:\ORACLE\PRODUCT\10.1.0\DPUDEV\ORADATA\DPU_DDATA.DBF':'g:\oracle\clay2\DPU_DDATA.DBF'
REMAP_DATAFILE='E:\ORACLE\PRODUCT\10.1.0\DPUDEV\ORA_INDX\DPU_DINDEX.DBF':'g:\oracle\clay2\DPU_DINDEX.DBF'
REMAP_DATAFILE='E:\ORACLE\PRODUCT\10.1.0\DPUDEV\ORADATA\DPU_FDATA.DBF':'g:\oracle\clay2\DPU_FDATA.DBF'
REMAP_DATAFILE='E:\ORACLE\PRODUCT\10.1.0\DPUDEV\ORA_INDX\DPU_NETINDEX.DBF':'g:\oracle\clay2\DPU_NETINDEX.DBF'
REMAP_DATAFILE='E:\ORACLE\PRODUCT\10.1.0\DPUDEV\ORADATA\DPU_NETDATA.DBF':'g:\oracle\clay2\DPU_NETDATA.DBF'
REMAP_DATAFILE='E:\ORACLE\PRODUCT\10.1.0\DPUDEV\ORADATA\DPU_NETWORK.DBF':'g:\oracle\clay2\DPU_NETWORK.DBF'
REMAP_DATAFILE='E:\ORACLE\PRODUCT\10.1.0\DPUDEV\ORADATA\PUID_DATA01.DBF':'g:\oracle\clay2\PUID_DATA01.DBF'
REMAP_DATAFILE='E:\ORACLE\PRODUCT\10.1.0\DPUDEV\ORADATA\TEMP2.DBF':'g:\oracle\clay2\TEMP2.DBF'