Home > Oracle > 12c clone PDB which has OMF file names

12c clone PDB which has OMF file names

Trying to clone a pdb database that has OMF file names failed with the following error

SQL> create pluggable database pdb1
2 AS CLONE using 'C:\oracle\xmlpdb\labpdb.xml'
4 FILE_NAME_CONVERT=('C:\oracle\oradata\testlab\91706876B2124CE1AB370C721351A0F6','C:\oracle\oradata\testlab\pdb1');
create pluggable database pdb1
ERROR at line 1:
ORA-01276: Cannot add file C:\ORACLE\ORADATA\TESTLAB\PDB1\DATAFILE\O1_MF_SYSTEM_9OKLBC83_.DBF. File has an Oracle
Managed Files file name.

to fix this issue i had to do the following

create pluggable database pdb1
AS CLONE using 'C:\oracle\xmlpdb\labpdb.xml'

Pluggable database created.

Categories: Oracle
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: