How to Drop a Pluggable Database

Close the Pluggable Database

SQL> ALTER PLUGGABLE DATABASE PDB1 CLOSE IMMEDIATE INSTANCES=ALL;

Drop PDB but Keep Datafiles

SQL>  DROP PLUGGABLE DATABASE PDB1 keep datafiles;

Drop PDB Including Datafiles

SQL>  DROP PLUGGABLE DATABASE PDB1 including datafiles;

Leave a comment

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