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.

Leave a Reply