<<Back to DB Administration Main Page
ORA-65005: missing or invalid file name pattern for file - +DATA/CDB01/TEMPFILE/temp.1667.989251537
CDB011> create pluggable database PDB01 using '/u01/stage/UNPLUG_DEF_PDB01.xml'SOURCE_FILE_NAME_CONVERT=('+DATA/CDB01/DATAFILE/','/u01/stage/')
MOVE
FILE_NAME_CONVERT = ('/u01/stage/', '+DATA_TEST');
create pluggable database PDB01 using '/u01/stage/UNPLUG_DEF_PDB01.xml'
*
ERROR at line 1:
ORA-65005: missing or invalid file name pattern for file - +DATA/CDB01/TEMPFILE/temp.1667.989251537
Solution
To resolve the issue I modified the UNPLUG_DEF_PDB01.xml manually. Identified and removed the temp file creation clause from XML definition file.
Remove the following portion from XMIL file and re-run the create PDB clause.
$ diff UNPLUG_DEF_PDB01.xml UNPLUG_DEF_PDB01_tmp.xml
< <name>TEMP</name>
< <type>1</type>
< <tsn>2</tsn>
< <status>1</status>
< <issft>0</issft>
< <bmunitsize>128</bmunitsize>
< <file>
< <path>+DATA/CDB01/TEMPFILE/temp.1667.989251537</path>
< <afn>42</afn>
< <rfn>1</rfn>
< <createscnbas>259862536</createscnbas>
< <createscnwrp>11</createscnwrp>
< <status>0</status>
< <fileblocks>2560</fileblocks>
< <blocksize>8192</blocksize>
< <vsn>2589488569</vsn>
< <autoext>1</autoext>
< <maxsize>4194302</maxsize>
< <incsize>80</incsize>
< </file>
< </tablespace>
< <tablespace>
Comments
Post a Comment