Clone PDB Locally (easy way)

¿How to clone PDB locally? ¿For example to clone PDB1 to PDB2 ? The steps are so easy:

Link from my github: https://github.com/felipower/scripts_oracle/blob/master/oracle_multitenant_PDB_local_clone__clonar_PDB_localmente.sql

/*

* Clone locally a PDB easy way

* author: Felipe Donoso, felipe@felipedonoso.cl, felipe.donoso@oracle.com

*/

[oracle@lab-db12-2-ol7 u01]$ sqlplus "/as sysdba"

SQL*Plus: Release 12.2.0.1.0 Production on Wed Aug 11 12:56:35 2021

Copyright (c) 1982, 2016, Oracle. All rights reserved.

Connected to:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

---------- ------------------------------ ---------- ----------

2 PDB$SEED READ ONLY NO

3 PDB1 READ WRITE NO

SQL> /* script for clone local PDB , remember change the folfer for the new datafiles for new pdb*/

CREATE PLUGGABLE DATABASE PDB2 FROM PDB1

FILE_NAME_CONVERT=('/u01/app/oracle/oradata/cdb1/pdb1/','/u01/app/oracle/oradata/cdb1/pdb2/')

-- Remember you can omit or include in the except list some tablespaces if you need

-- USER_TABLESPACES=('xxx', 'yyyy')

-- omit the clause USER_TABLESPACE is the same that use USER_TABLESPACES=ALL

--

-- Also remember you can clone only metadata if you need (no rows)

-- using NO DATA option

-- the NO DATA option above is valid only when you aren't using:

; 2 3 4

Pluggable database created.

SQL> ALTER PLUGGABLE DATABASE pdb2 OPEN;

Pluggable database altered.

SQL> ALTER PLUGGABLE DATABASE pdb2 save state;

Pluggable database altered.

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

---------- ------------------------------ ---------- ----------

2 PDB$SEED READ ONLY NO

3 PDB1 READ WRITE NO

4 PDB2 READ WRITE NO

SQL>

DONE! :D