Drop Pluggable Database in Oracle

Drop PDB commands in Oracle.

Check the status of PDBs present in Oracle Database:

SQL> show pdbs;
   CON_ID CON_NAME                   OPEN MODE  RESTRICTED
--------- -------------------------- ---------- ----------
        3 PDB3                       READ WRITE NO
        4 PDB4                       READ WRITE NO
OR 

SQL>  select con_id, name,open_mode from v$containers;

For dropped the database, we must shut down or close the PDB database:

SQL> alter pluggable database pdb4 close;

Pluggable database altered.

For drop the PDB database has two options:

Drop with including Datafiles:

SQL> drop pluggable database pdb4 including datafiles;
Pluggable database dropped.

Drop with keep datafiles:

SQL> drop pluggable database pdb4 keep datafiles;
Pluggable database dropped.
This entry was posted in Oracle on by .
Unknown's avatar

About SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply