How to Create Oracle Pluggable Database

<<Back to DB Administration Main Page

Creating Pluggable Database (PDB)

Step1> Login to the database as sysdba
Step2> Run create pluggable database command from CDB$ROOT container
SQL> create pluggable database PDB01 admin user admin identified  by password;
Pluggable database created.
SQL> show pdbs
    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB01                          MOUNTED
Step3> Open Pluggable Database in read/write mode
SQL> alter pluggable database PDB01 open;
Pluggable database altered.
SQL> show pdbs
    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB01                          READ WRITE NO
Step4> Save the Pluggable Database state
SQL> select CON_ID,CON_NAME,INSTANCE_NAME,STATE from DBA_PDB_SAVED_STATES;
no rows selected
SQL> alter pluggable database PDB01 save state;
Pluggable database altered.
SQL>  select CON_ID,CON_NAME,INSTANCE_NAME,STATE from DBA_PDB_SAVED_STATES;
    CON_ID CON_NAME   INSTANCE_N STATE
---------- ---------- ---------- --------------
         3 PDB01      TST1T      OPEN