Creating Oracle Multitenant Databases - OCP: Oracle Database 12c Administrator Certified Professional - page 533

SQL> @%ORACLE_HOME%\RDBMS\ADMIN\noncdb_to_pdb.sql
SQL>
SQL> alter pluggable database LNE2 open;
Pluggable database altered.
Following the creation of a PDB using SQL*Plus and running the neces-
sary script, confirm that the PDB is in a usable state. Before running the
noncdb_to_pdb.sql script, the LNE2 PDB looks like this:
SQL> col pdb_name form a20
SQL> SELECT PDB_NAME, STATUS FROM DBA_PDBS;
PDB_NAME STATUS
-------------------- -------------
LNE1 NORMAL
PDB$SEED NORMAL
PDB3 NORMAL
LNE4 NORMAL
LNE2 NEW
After running the noncdb_to_pdb.sql script, the LNE2 PDB looks like this:
SQL> SELECT PDB_NAME, STATUS FROM DBA_PDBS;
PDB_NAME STATUS
-------------------- -------------
LNE1 NORMAL
PDB$SEED NORMAL
PDB3 NORMAL
LNE4 NORMAL
LNE2 NORMAL
SQL>