My Oracle Support Banner

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 OCTOBER 06, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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