Ora-04023 Reported while Accessing Valid Objects

刘泽宇

现象：

Select against a view  fails with following error.

SQL> Select * from <schema>.<viewname> ;

ORA-04023: could not be validated or authorized

造成原因：

This is issue is due to a timestamp inconsistency in the data

dictionary. This timestamp inconsistency will lead to the problem when we

populate the relevant cached objects and later try to select from the

affected views.

处理方法：

Run following script to find out the objects which are having timestamp discrepancies.

Connect as / as sysdba

SQL> @?/rdbms/admin/utldtchk.sql

This script is available from 11g onwards.

Recompile all the objects manually returned by this script.

It will remove the timestamp inconsistency in data dictionary and resolve this issue.


参照官方文档 ID：1610514.1