How to Rename a Pluggable Database
Oracle 12c
How to rename a container (pluggable database).
Step-By-Step
0.) Optional –
alter session set container=pdb1;
show con_name
1. Shutdown the pluggable database (PDB).
sqlplus ‘/ as sysdba’
SQL> shutdown pluggable database myplugdb3 close immediate;
or if connected to pdb
shutdown immediate;
2. Startup the PDB in restricted mode
sqlplus ‘/ as sysdba’
SQL> alter pluggable database myplugdb3 open restricted;
or if connected to pdb
startup restrict;
3. Rename the PDBs
sqlplus ‘/ as sysdba’
SQL> connect pdb1 as sysdba
SQL> alter pluggable database pdb1 rename global_name to jobs;
4. Restart the PDB
sqlplus ‘/ as sysbda’
SQL> alter pluggable database close immediate;
SQL> alter pluggable database open;
or if connected to pdb
shutdown immediate;
startup;
alter session set container=cdb$root;
select name from v$pdbs;
NAME
——————————————————————————————————————————–
PDB$SEED
JOBS
PDB1_CLONE
PDB2
Reference:
http://www.oracle-wiki.net/premium:startdocsminimultirename