Oracle 12C--Clone a non-cdb as a PDB

Set NON-CDB to read-only mode:

$ sqlplus'/as sysdba'SQL>SelectName, Decode (CDB,'YES','multitenant Option enabled','Regular 12c Database:')"multitenant Option", Open_mode, con_id fromv$database; NAME multitenant Option open_mode con_id--------- -------------------------- -------------------- ----------TEST Regular 12c database:read WRITE0SQL>shutdown immediate; SQL> startup open Read only;

Connect to the CDB, create a dblink, connect to NON-CDB:

$ sqlplus'/as sysdba'SQL>SelectName, Decode (CDB,'YES','multitenant Option enabled','Regular 12c Database:')"multitenant Option", Open_mode, con_id fromv$database;name multitenant Option open_mode con_id--------- -------------------------- -------------------- ----------ORA12 multitenant Option enabled READ WRITE0SQL> CREATE DATABASE link link_test connect to system identified by Oracleusing 'Test';

Clone the NON-CDB and execute the script:

 from [Email protected]_test create_file_test='/u12/app/oracle/oradata/pdb_test'; SQLSet container=pdb_test; SQL> @ $ORACLE _home/rdbms/admin/noncdb_to_pdb;

Open a cloned database:

sql> Alter pluggable database pdb_test open;

Oracle 12C--Clone a non-cdb as a PDB