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');