- 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 :
1 2 3 4 5 6 7 8 9 | SQL> alter session set container=pdbtest;Session altered.SQL>SQL> shutdown immediate;Pluggable Database closed.SQL> startup open restrictPluggable Database opened. |
Rename the PDB
1 2 3 4 5 6 7 8 9 10 11 | SQL> alter pluggable database pdbtest rename global_name to pdbdb;Pluggable database altered.SQL>SQL> show con_name;CON_NAME------------------------------PDBDBSQL> |
Restart the PDB
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 | SQL> shutdown immediate;Pluggable Database closed.SQL>SQL>SQL> startupPluggable 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 NOSQL> |