Home » RDBMS Server » Server Utilities » impdp REAMP_DATAFILE arghhhh
impdp REAMP_DATAFILE arghhhh [message #230393] Wed, 11 April 2007 14:24 Go to next message
SGT_6120
Messages: 4
Registered: April 2007
Location: Missouri
Junior Member
I am having the most difficult time trying to use the impdp tool. The format of the REMAP_DATAFILE keeps bouncing an error of bad value.

UDI-00014: invalid value or parameter, 'remap_datafile'

Here is my .par file.

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'

Much Obliged,
-Steve

[Updated on: Wed, 11 April 2007 14:36] by Moderator

Report message to a moderator

Re: impdp REAMP_DATAFILE arghhhh [message #230394 is a reply to message #230393] Wed, 11 April 2007 14:37 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Did you try with a single REMAP_DATAFILE parameter?
Something like
REMAP_DATAFILE='FILE1:ANOTHER_FILE1','FILE2:ANOTHERFile2'

[Updated on: Wed, 11 April 2007 14:55]

Report message to a moderator

Re: impdp REAMP_DATAFILE arghhhh [message #230414 is a reply to message #230394] Wed, 11 April 2007 21:25 Go to previous messageGo to next message
SGT_6120
Messages: 4
Registered: April 2007
Location: Missouri
Junior Member
I have tried a single REMAP_DATAFILE in a parameter file. I have tried the comma between two different remaps, I have tried it at the command line and using Enterprise Mangler.

Report message to a moderator

Re: impdp REAMP_DATAFILE arghhhh [message #230416 is a reply to message #230414] Wed, 11 April 2007 21:33 Go to previous messageGo to next message
SGT_6120
Messages: 4
Registered: April 2007
Location: Missouri
Junior Member
I have even tried dbl quotes.....

Report message to a moderator

Re: impdp REAMP_DATAFILE arghhhh [message #245803 is a reply to message #230416] Mon, 18 June 2007 18:36 Go to previous messageGo to next message
mcalisdg
Messages: 1
Registered: June 2007
Junior Member
sgt 6120, did you ever resolve this issue. I'm on windows and having problems remapping multiple datafiles, it's my first time with the new impdp, any pointers would be great.

Report message to a moderator

Re: impdp REAMP_DATAFILE arghhhh [message #245805 is a reply to message #245803] Mon, 18 June 2007 18:42 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Exact i guess what you looking for.

http://elandingstest.alaska.gov/confluence/display/IERS/Loading+Database+via+DataPump

Report message to a moderator

Re: impdp REAMP_DATAFILE arghhhh [message #246001 is a reply to message #230393] Tue, 19 June 2007 09:37 Go to previous message
SGT_6120
Messages: 4
Registered: April 2007
Location: Missouri
Junior Member
Here is what I got to work. Syntax sensitive and Including the back slash "\" as an escape to the quotes did the trick....


Full=Y
directory=dpump_dir
Logfile=implog55.log
dumpfile=dpu.dmp
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'\

Report message to a moderator

Previous Topic: Unable to export Table having CLOB data type
Next Topic: EXP-00003: no storage definition found for segment(25, 19)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jun 26 14:05:18 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.