Posts

Showing posts from March 29, 2020

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...