ORA-04023: Could Not Be Validated Or Authorized and all Objects are Known to be Valid
(Doc ID 2212893.1)
Last updated on DECEMBER 11, 2020
Applies to:Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
- A SELECT query that has worked in the past now throws an ORA-04023 error.
- Doc ID 1610514.1 has been followed and no objects were returned OR all objects returned were recompiled and the error is still occurring.
- Materialized Views are in use for the target of the SELECT query.
- Zone maps are being used.
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