Oracle 12C-Use local PDB to clone new PDB

1. The PDB to be used for cloning as read-only status: Startup Open Read Only

Select  from V$pdbs;    con_id NAME                           open_mode--------------------------------------------------         2  pdb$seed                       READ          only 3 PDB1                           Mounted         4  P4                             mountedsqlset container=pdb1; SQL> ALTER DATABASE open Read only;

2. Login CDB

Sql> Connect/ asSysdbasql> Create pluggable Database pdb2 fromPDB1 file_name_convert= ('PDB1','PDB2'); SQL> Alter SESSIONSetContainer=pdb2; SQL>Startupsql>SelectCon_id,name,open_mode fromV$pdbs; con_id NAME Open_mode---------- ------------------------------ ----------2pdb$seed READ only3PDB1 READ only4P4 Mounted5PDB2 READ Writesql>

3. Open the original PDB

set container=pdb1; SQL> shutdownsql> Startup

Oracle 12C-Use local PDB to clone new PDB