Pluggable Database Rename in Oracle Container Database 12cR1

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

100.png

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

101.png

102.png

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

103.png

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

104.png

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:

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