Datafiles for a materialized snapshot copy are dropped when "delete pluggable database <pdb_name> keep data files" is executed. (Doc ID 2966945.1)

Last updated on AUGUST 09, 2023

Applies to:

Symptoms

Problem Summary
---------------------------------------------------
The command "drop pluggable database <pdb_name> keep datafiles;" drops the datafiles for a materialized snapshot copy.

Problem Description Example
---------------------------------------------------

-- Create PDB - snapshot copy
SQL> CREATE PLUGGABLE DATABASE <pdb_name> FROM <OLDPDB> CREATE_FILE_DEST='<Path>/CDB/NEWPDB' SNAPSHOT COPY;     <<==== PDB SNAPSHOT COPY
Pluggable database created.
 
--PDB Datafiles   
>                                  
temp.dbf
users.dbf
undotbs1.dbf
sysaux.dbf
system.dbf
 
--MATERIALIZE
SQL> alter pluggable database <pdb_name> open;
SQL> alter session set container=<pdb_name>;
SQL> ALTER PLUGGABLE DATABASE MATERIALIZE;                                                         <<==== MATERIALIZE
Pluggable database altered.
 
--Drop PDB including datafiles
SQL> alter pluggable database <pdb_name> close immediate;
SQL> alter pluggable database <pdb_name> unplug into '<Path>/<pdb_name>.xml';
SQL> drop pluggable database <pdb_name> keep datafiles;                                           <<==== KEEP DATAFILES                          
Pluggable database dropped.
 
--PDB Datafiles
>
total 0                                                                                                                         <<====-Datafiles were dropped                                                        
                                                              

Changes

Enh 35437189

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.