Step 6:- See the status of Pluggable databases

SQL> show pdbs

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

Step 7:- Let’s us create the pluggable database ICAPDB1

       To create a pluggable database give the following command

SQL>CREATE PLUGGABLE DATABASE icapdb1 ADMIN USER icapdb1adm IDENTIFIED BY tiger
STORAGE (MAXSIZE 2G MAX_SHARED_TEMP_SIZE 100M)
DEFAULT TABLESPACE users
DATAFILE '/u02/oracle/icacdb/icapdb1/users01.dbf'
SIZE 250M AUTOEXTEND ON
FILE_NAME_CONVERT = ('/u02/oracle/icacdb/pdbseed/',
'/u02/oracle/icacdb/icapdb1/');

To view list of PDB’s

SQL> show pdbs

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

Now open the pluggable database

SQL>alter pluggable database icapdb1 open;

See the status

SQL> show pdbs

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

To switch to Pluggable database give the following command

SQL>alter session set container=icapdb1

To view current container, give the following command

SQL> show con_name