ORA-65179: cannot keep datafiles for a pluggable database that is not unplugged
Cause:
[oracle@xhydra ~]$ oerr ora 65179
65179, 00000, "cannot keep datafiles for a pluggable database that is not unplugged"
// *Cause: An attempt was made to drop a pluggable database without
// specifying the INCLUDING DATAFILES clause, and the pluggable
// database has not been unplugged.
// *Action: Unplug the pluggable database before dropping the pluggable
// database or use the INCLUDING DATAFILES clause in the
// DROP PLUGGABLE DATABASE statement.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
kIsH@Xhydra<>drop pluggable database pdbtsnt1;
drop pluggable database pdbtsnt1
*
ERROR at line 1:
ORA-65179: cannot keep datafiles for a pluggable database that is not unplugged
Action:
kIsH@Xhydra<>sho pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB MOUNTED
4 PDBTSNT1 MOUNTED
kIsH@Xhydra<>alter pluggable database PDBTSNT1 unplug into '/tmp/pdb.xml';
Pluggable database altered.
kIsH@Xhydra<>drop pluggable database pdbtsnt1;
Pluggable database dropped.
or
kIsH@Xhydra<>drop pluggable database PDBTSNT1 including datafiles;
Pluggable database dropped.