ORA-65005: missing or invalid file name pattern for file –

ORA-65005: missing or invalid file name pattern for file –

Cause:

Syntax issue in FILE_NAME_CONVERT parameter

SQL> CREATE PLUGGABLE DATABASE newpdb USING '/tmp/ncdb.xml'
  COPY
  FILE_NAME_CONVERT=("/u01/app/oracle/oradata/XSCALIBAL/","/apps01/oradata/HYDRA");  2    3
  FILE_NAME_CONVERT=("/u01/app/oracle/oradata/XSCALIBAL/","/apps01/oradata/HYDRA")
                     *
ERROR at line 3:
ORA-65005: missing or invalid file name pattern for file -

Solution:

SQL> CREATE PLUGGABLE DATABASE newpdb USING '/tmp/ncdb.xml'
  2  COPY
  3  FILE_NAME_CONVERT=('/u01/app/oracle/oradata/XSCALIBAL/','/apps01/oradata/HYDRA');

Leave a Reply

%d bloggers like this: