Rename Pluggable Database (PDB)

1. Connect to the Sqlplus as SYSDBA

SQL> sho pdbs;

CON_ID CON_NAME OPEN MODE RESTRICTED
------ -------- --------- ----------
2 PDB$SEED    READ ONLY   NO

3 PDBMIG   READ WRITE  NO

2. Shutdown PDB which need to rename

  SQL> alter pluggable database PDBMIG close immediate;

3. Open as restricted mode

SQL> alter pluggable database PDBMIG open restricted;

4. Rename PDB

  SQL> alter pluggable database PDBMIG rename global_name to PDBTEST;

5. Restart PDB

  SQL> alter pluggable database PDBTEST close immediate;
  SQL> alter pluggable database PDBTEST open;

6. Connect to PDB and verify

  SQL> show pdbs;
  SQL> select name, open_mode, restricted from v$pdbs;
SQL> select name, con_id, dbid,con_uid, guid from v$containers;
SQL> select service_id, name, network_name, creation_date, pdb, con_id from cdb_services;

7. Change datafile path as per new PDB (Optional)

  SQL> alter database move datafile '/u01/oradata/CDB1/PDBMIG/system01.dbf' to '/u01/oradata/CDB1/PDBTEST/system01.dbf';

For Temp File, Drop and re-create

  SQL> alter database tempfile '/u01/oradata/CDB1/PDBMIG/temp01.dbf' drop including datafiles;
SQL> alter tablespace TEMP add tempfile '/u01/oradata/CDB1/PDBTEST/temp01.dbf' size 1G reuse;