Dropping Pluggable Database :

We can drop the pluggable database using DROP PLUGGABLE DATABASE statement from the root container.

Let’s try dropping one pdb

Step 1: Check which pdb you want to drop

Step 2: Close pluggable database

Step 3: Drop pdb2

It is giving me an error. As we cannot keep datafiles when we are dropping that pdb unless we have unplugged it.

So let’s drop it using including datafiles clause.

We can see here the pluggable database is dropped.

If you want to be updated with all our articles send us an Invitation or Follow us:

Telegram Channel: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply

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