ORA-65179: cannot keep datafiles for a pluggable database that is not unplugged

Cause:

First dump the PDB details into XML files

kIsH@Xhydra<>drop pluggable database ZXPDB5;
drop pluggable database ZXPDB5
*
ERROR at line 1:
ORA-65179: cannot keep datafiles for a pluggable database that is not unplugged

Action:

Unplug the PDB first into XML file and try a drop

kIsH@Xhydra<>alter pluggable database ZXPDB5 unplug into '/tmp/to_drop.xml';

Pluggable database altered.

kIsH@Xhydra<>drop pluggable database ZXPDB5;

Pluggable database dropped.

Leave a Reply