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;
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