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 .

About SandeepSingh DBA

Hi, I am working in IT industry with having more than 10 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

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.