While dropping the PDB, we receive the error like cannot keep datafiles for a pluggable database that is not unplugged.

SQL> show pdbs

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

SQL> alter pluggable database PDB18C2 close;

Pluggable database altered.

SQL> drop pluggable database PDB18C2;
drop pluggable database PDB18C2
*
ERROR at line 1:
ORA-65179: cannot keep datafiles for a pluggable database that is not unplugged

Solution:

SQL> drop pluggable database PDB18C2 including datafiles;

Pluggable database dropped.

SQL>

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the 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

Leave a Reply

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