重庆思庄Oracle、Redhat认证学习论坛

标题: Ora-04023 Reported while Accessing Valid Objects [打印本页]

作者: 刘泽宇 时间: 2021-1-31 16:50
标题: Ora-04023 Reported while Accessing Valid Objects
本帖最后由刘泽宇于 2021-1-31 16:52 编辑

现象：

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

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)