Issue
Getting the following error while recompiling a specific database object:
alter view UAB_RT_EXEC_PROC_RUN_COUNTS compile
*
ERROR at line 1:
ORA-04023: Object alter view UAB_RT_EXEC_PROC_RUN_COUNTS compile
Root cause of the issue
Possibly the there are issues in the shared pool, which could be related to some form of data corruption. Simply flush the shared pool to get rid of this issue.
Resolution
Step 1. Login as sysdba and flush the shared pool
sqlplus / as sysdba
alter system flush shared_pool;
Step 2. Now try to recompile the package again:
conn owbsys/owbsys
alter view UAB_RT_EXEC_PROC_RUN_COUNTS compile
package altered
Environment