Tuesday 12 March 2013

ORA-4023 WHEN SELECTING FROM VIEW

ORA-4023 WHEN SELECTING FROM VIEW
                                  OR
ora-04023 summary object could not be validated


PROBLEM:
--------
When executing SELECT on a view which is used in the proc it is throwing
ORA-4023 error but the object status shows VALID only. After dropping and
recreating view works fine for some time then again results in ORA-4023.


DIAGNOSTIC ANALYSIS:
--------------------
Requested the customer, if the error repeats again, to set
set events '4023 trace name ERRORSTACK level 12';
and upload the error stack.


alter system flush shared_pool;

No comments:

Post a Comment