ORA-01405 error while dropping a PDB (Doc ID 2864112.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

When trying to drop a PDB, but it fails with "ORA-01405: fetched column value is NULL"

  CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
  2            PDB$SEED READ ONLY   YES
  3            TEST01     MOUNTED

SQL> drop pluggable database TEST01 keep datafiles;
drop pluggable database TEST01 keep datafiles
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01405: fetched column value is NULL

Cause

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