ORA-04023: Object could not be validated or authorized



ORA- Error:


SQL>SELECT DAT.*,DATE_MODE||';'||SYS_META_KEY MIS_XDISPARE
FROM MIS_SYS_DATA DAT WHERE 1 = 0 

ORA-04023: Object could not be validated or authorized


Cause: 

Timestamp mismatch between dependent objects.


Solution: 

Run utldchk.sql script to identify objects with timestamp mismatch and compile both dependent objects manually , re-run utldchk.sql to verify the object is not listed under mismatched object list.

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

D_OWNER   D_NAME       P_OWNER   P_NAME           REASON

--------- ------------ --------- ----------    ----------------------

TEST_USER MIS_SYS_DATA TEST_USER MIS_SYS_P_DATA  TS mismatch:

                                                 16-JUN-20 07:42:02

                                                 30-JUN-20 06:16:17

 

SQL>alter view MIS_SYS_P_DATA compile;

SQL>alter procedure MIS_SYS_DATA compile;


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



Solved !!




No comments:

Post a Comment