4 Replies Latest reply on Apr 13, 2007 3:01 PM by 59640

    Data Pump Woes - REMAP_DATAFILE

    572202
      I 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'