ORA-65016: FILE_NAME_CONVERT must be specified

Cause:

Destination PDB doesnot exactly know, where to put the datafiles as mentioned in source PDB. Since directory of source and destination should be different if both conflict.

kIsH@STAX<>create pluggable database prox1 as proxy from prox1@prox_link;
create pluggable database prox1 as proxy from prox1@prox_link
                                                            *
ERROR at line 1:
ORA-65016: FILE_NAME_CONVERT must be specified

Solution:

  1. Specify FILE_NAME_CONVERT clause explicitly in the command
kIsH@STAX<>create pluggable database prox2 as proxy from prox2@prox_link FILE_NAME_CONVERT=('/u01/app/oracle/oradata/ORCL/','/u01/app/oracle/oradata/STAXDB/');

2. Use pdb_file_name_convert

kIsH@STAX<>show parameter pdb_file_name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
pdb_file_name_convert                string

kIsH@STAX<>alter system set pdb_file_name_convert='/u01/app/oracle/oradata/ORCL/ORCL/','/u01/app/oracle/oradata/STAXDB/';

System altered.
kIsH@STAX<>show parameter pdb_file_name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
pdb_file_name_convert                string      /u01/app/oracle/oradata/ORCL/O
                                                 RCL/, /u01/app/oracle/oradata/
                                                 STAXDB/

3. Use db_create_file_dest

kIsH@STAX<>show parameter db_create_file

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_create_file_dest                  string
kIsH@STAX<>alter system set db_create_file_dest='/u01/app/oracle/oradata/STAXDB/';

System altered.

kIsH@STAX<>create pluggable database prox1 as proxy from prox1@prox_link;

Pluggable database created.

Leave a Reply