In this blog , we will see how to Rename A Pluggable Database ( PDB) ?
SQL> alter session set container=pdbtest; Session altered. SQL> SQL> shutdown immediate; Pluggable Database closed. SQL> startup open restrict Pluggable Database opened.
SQL> alter pluggable database pdbtest rename global_name to pdbdb; Pluggable database altered. SQL> SQL> show con_name; CON_NAME ------------------------------ PDBDB SQL>
SQL> shutdown immediate; Pluggable Database closed. SQL> SQL> SQL> startup Pluggable Database opened. SQL> alter session set container=CDB$ROOT; Session altered. SQL> show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 PDBDB READ WRITE NO 4 ABC READ WRITE NO SQL>