Skip to content

How to Resolve ORA-65005: missing or invalid file name pattern for file

  • by
  • October 19, 2015March 31, 2021

ORA-65005

ORA-65005 means that the pattern of file name conversion you specified in CREATE PLUGGABLE DATABASE statement does not match the data files.

SQL> create pluggable database orclpdb2 from orclpdb1 storage unlimited tempfile reuse file_name_convert=('orclpdb1', 'orclpdb2');
create pluggable database orclpdb2 from orclpdb1 storage unlimited tempfile reuse file_name_convert=('orclpdb1', 'orclpdb2')
*
ERROR at line 1:
ORA-65005: missing or invalid file name pattern for file -
/u01/app/oracle/oradata/ORA19C1/ORCLPDB1/system01.dbf

This is usually because you specified an invalid value of FILE_NAME_CONVERT. In this case, Oracle found that the path of system01.dbf cannot be converted into a valid path according to FILE_NAME_CONVERT.

That's right, 'orclpdb1' is different from 'ORCLPDB1'.

Solution

To solve ORA-65005, you should make sure the file name pattern of source PDB you specified in FILE_NAME_CONVERT is valid and case-sensitive.

In this case, we should uppercase the pattern of file name conversion.

SQL> create pluggable database orclpdb2 from orclpdb1 storage unlimited tempfile reuse file_name_convert=('ORCLPDB1', 'ORCLPDB2');

Pluggable database created.

Leave a Reply

Your email address will not be published.