- 17 Aug, 2023
- 0 Comments
- 53 Secs Read
Rename A Pluggable Database ( PDB)
How to rename a Pluggable Database (PDB?)
In this blog , we will see how to Rename A Pluggable Database ( PDB) ?
- Start Pluggable Database with restrict mode :
SQL> alter session set container=pdbtest; Session altered. SQL> SQL> shutdown immediate; Pluggable Database closed. SQL> startup open restrict Pluggable Database opened.
Rename the PDB
SQL> alter pluggable database pdbtest rename global_name to pdbdb; Pluggable database altered. SQL> SQL> show con_name; CON_NAME ------------------------------ PDBDB SQL>
Restart the PDB
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>