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

My Environment where tested: OCI DBCS 19c



SQL> alter session set container=OCIBENCH;


Session altered.


SQL> drop pluggable database OCIBENCH;

drop pluggable database OCIBENCH

*

ERROR at line 1:

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



SQL> drop pluggable database OCIBENCH including datafiles;


Pluggable database dropped.


SQL> 


SQL> sho pdbs


    CON_ID CON_NAME   OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

2 PDB$SEED   READ ONLY  NO

3 ORCL_PDB1   READ WRITE NO

SQL> 


Comments

Post a Comment

Popular posts from this blog

ORA-46697: Keystore password required - create pluggable database pdb1clone from pdb1

  select con_id,name,open_mode from v$pdbs;     CON_ID NAME     OPEN_MODE ---------- -------------------------------------------------------------------------------------------------------------------------------- ---------- 2 PDB$SEED     READ ONLY 3 PDB1     READ WRITE SQL> create pluggable database pdb1clone from pdb1; create pluggable database pdb1clone from pdb1 * ERROR at line 1: ORA-46697: Keystore password required. Solution: If  TDE is configured, you have to supply the keystore password  SQL> CREATE PLUGGABLE DATABASE PDB1clone FROM PDB1  KEYSTORE IDENTIFIED BY password;
Read more