My Oracle Support Banner

ORA-65040: operation not allowed from within a pluggable database when trying to remove an APEX object (Doc ID 2767876.1)

Last updated on AUGUST 20, 2021

Applies to:

Oracle Application Express (APEX) - Version 4.2 and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

 ==>> On the PDB tryied to remove an apex Object like  sys.VALIDATE_APEX or WWV_FLOW_VAL_LIB

sample code:
SQL> drop procedure sys.VALIDATE_APEX;
drop procedure sys.VALIDATE_APEX
*
ERROR at line 1:
ORA-65040: operation not allowed from within a pluggable database


===>> On the CDB the object do NOT exist
SQL> show con_name

sample code:
CON_NAME
------------------------------
CDB$ROOT

SQL> DROP PROCEDURE VALIDATE_APEX;
DROP PROCEDURE VALIDATE_APEX

*
ERROR at line 1:
ORA-04043: object VALIDATE_APEX does not exist

Changes

 Removed APEX from the CDB and this objects were found left behind in PDB only

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

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