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;

Leave a Reply

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

WordPress.com Logo

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

Google photo

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

Twitter picture

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

Facebook photo

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

Connecting to %s