ORA-65040: operation not allowed from within a pluggable database when trying to remove an APEX object
(Doc ID 2767876.1)
Last updated on JANUARY 23, 2023
Applies to:
Oracle Application Express (APEX) - Version 4.2 and laterOracle 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 |