<<Back to DB Administration Main Page
SQL> create pluggable database PDB01 admin user pdb01 identified by pdb01 file_name_convert=('+DG_FLEX_DATA','+DG_TST_DATA');
create pluggable database PDB01 admin user pdb01 identified by pdb01 file_name_convert=('+DG_FLEX_DATA','+DG_TST_DATA')
*
ERROR at line 1:
ORA-65005: missing or invalid file name pattern for file -
+DG_TST_DATA/TST1T/7637E1C08DFB31DFE0530601A8C097C7/DATAFILE/system.262.98725137
7
Cause
Issue in Create Pluggable Database statement. I made a mistake and supplied the diskgroup in incorrect order in file_name_convert parameter
Solution
SQL> create pluggable database PDB01 admin user pdb01 identified by pdb01 file_name_convert=('+DG_TST_DATA','+DG_FLEX_DATA');
Pluggable database created.
Also Add Temp file to the file_name_convert part of the Create Pluggable database statement
Comments
Post a Comment