How To Rename A Pluggable Database- PDB


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;
6. Verify
select name,open_mode from v$pdbs;

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s