Skip to Main Content

Oracle Database Discussions

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Data Pump Woes - REMAP_DATAFILE

572202Apr 12 2007 — edited Apr 13 2007
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'

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 11 2007
Added on Apr 12 2007
4 comments
1,389 views