How to rename a Pluggable database in oracle database?
How to rename a Pluggable database??? SQL> -- we will change the name of container database STSPDB to WALPDB SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 3 STSPDB READ WRITE NO SQL> shutdown immediate; Pluggable Database closed. SQL> SQL> SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 3 STSPDB MOUNTED SQL> startup open restrict; Pluggable Database opened. SQL> SQL> SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 3 STSPDB READ WRITE YES SQL> SQL> SQL> alter pluggable database STSPDB rename global_name to WALPDB; Pluggable database