Creating A New PDB In A Local CDB By Clone From A Remote PDB (Doc ID 2948752.1)

Last updated on MAY 26, 2023

Applies to:

Goal

getting the following error message when doing some of the final steps cloning a PDB from a remote CDB.
Both the command and the error message are just below:

SQL> create pluggable database pdb1 from pdb2@clone_link;
create pluggable database pdb1 from pdb2@clone_link
*
ERROR at line 1:
ORA-65294: PDB's compatible parameter value (19.0.0.0.0) is higher than CDB's
compatible parameter value (12.1.0.2.0).

In the local CDB 

SQL> sho parameter compatible

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
compatible string 12.1.0.2


on the PDB
========

SQL> show parameter compatible

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
compatible string 19.0.0.0
noncdb_compatible boolean FALSE
SQL>
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.