7 Replies Latest reply on Jan 10, 2013 8:09 AM by 950599

    Is it posisble to use DB_FILE_NAME_CONVERT to rename datafile names


      I want to clone a database on the same server.
      My datafiles start with the name of the SID, for examplel: /u04/oradata/ORACP/ORACP_applic_data_01.dbf'

      I want to use "duplicate fom active database", but with the parameter DB_FILE_NAME_CONVERT i can only change the directory to clone the datafile to, but the datafile itself is not renamed.

      I am correct?

      Is the only way to solve this, to use SET NEWNAME for all the datafiles to clone?

      Any help is appreciated.