How to create Oracle pluggable database

 

Step1> Login to the database as sysdba

Step2> Run create pluggable database command from CDB container

SQL> create pluggable database PDB1 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 PDB1                                MOUNTED

Step3> Open pluggable database in read/write mode

SQL> alter pluggable database PDB1 open;
Pluggable database altered.

SQL> show pdbs
    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB1                                READ WRITE NO

Step4> Save the pluggable database state

SQL> alter pluggable database PDB1 save state;

Pluggable database altered.