Rename PDB in 12.2
Create test pdb called s24pdb: SQL> create pluggable database s24pdb admin user s24test identified by ****; Pluggable database created. SQL> alter pluggable database S24PDB open; Pluggable database altered. SQL> sho pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 TEST1 READ WRITE NO 5 S24PDB READ WRITE NO SQL> alter pluggable database S24PDB close; Pluggable database altered. SQL> alter pluggable database S24PDB open restricted; Pluggable database altered. SQL> sho pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 TEST1 READ WRITE NO 5 S24PDB