Home » RDBMS Server » Server Utilities » REMAP_DATAFILES parameter (11gR2 Window 2008)
REMAP_DATAFILES parameter [message #568509] Fri, 12 October 2012 11:16 Go to next message
jxh461
Messages: 185
Registered: March 2005
Senior Member
Can the remap_datafiles take multiple parameters seperated by a comma as follows ?

remap_datafile='/oracle/FCLPTPRD/data01/b01.dbf' : 'C:\APP\ORACLE\ORADATA\BIPL2\b01.dbf',
'/oracle/FCLPTPRD/data01/s01.dbf':'C:\APP\ORACLE\ORADATA\BIPL2\s01.dbf',
'/oracle/FCLPTPRD/data01/w01.dbf':'C:\APP\ORACLE\ORADATA\BIPL2\w01.dbf',
'/oracle/FCLPTPRD/data01/bi_01.dbf';'C:\APP\ORACLE\ORADATA\BIPL2\bi_01.dbf',
'/oracle/FCLPTPRD/data01/vwh_01.dbf':'C:\APP\ORACLE\ORADATA\BIPL2\vwh_01.dbf'

Please polite in your feedback and thanks in advance.

Report message to a moderator

Re: REMAP_DATAFILES parameter [message #568510 is a reply to message #568509] Fri, 12 October 2012 11:28 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You can use several remap_datafile lines (if you don't know or don't want to test, this is the polite part).

Regards
Michel

Report message to a moderator

Re: REMAP_DATAFILES parameter [message #568511 is a reply to message #568510] Fri, 12 October 2012 12:07 Go to previous message
jxh461
Messages: 185
Registered: March 2005
Senior Member
Merci Monsieur

Report message to a moderator

Previous Topic: EXP-00011: SCOTT.BONUS does not exist
Next Topic: Loading the CLOB data into table
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Feb 11 18:20:58 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.