How To Rename A Pluggable Database- PDB

Hi,

I need to rename a pluggable database. It is so easy to rename.7

Let’s do it step by step:

1. Firstly set containter to PDB named DEV

alter session set container=DEV;

2. shutdown and open it in restricted mode.

shutdown immediate;

startup open restrict;

3. Now rename the PDB

alter pluggable database DEV rename global_name to ACC;

4. Check it

show con_name;

show pdbs;

5. shutdown and start in normal mode.

shutdown immediate;

startup;

6. Verify

select name,open_mode from v$pdbs;

Advertisement