Pluggable Database Rename in Oracle Container Database 12cR1

1.. Connect to root container as sysdba then show pdbs


2.. First shutdown pluggable database and then open in restricted mode for e.g NONPDB4



3.. Now connect to Pluggable database NONPDB4 that you want to change the name.


4.. execute alter pluggable database rename global_name to DEMO;


Note :- There will be change in name of PDB but not with CON_ID, directory where datafile of PDB resides.

Happy Learning !!!!

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 )

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