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: 175
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.
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: 57605
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: REMAP_DATAFILES parameter [message #568511 is a reply to message #568510] Fri, 12 October 2012 12:07 Go to previous message
jxh461
Messages: 175
Registered: March 2005
Senior Member
Merci Monsieur
Previous Topic: EXP-00011: SCOTT.BONUS does not exist
Next Topic: Loading the CLOB data into table
Goto Forum:
  


Current Time: Thu Apr 17 07:38:28 CDT 2014

Total time taken to generate the page: 0.11250 seconds