Oracle SYS.DBMS_IREFRESH error# Database - 数据库
w*m
1 楼
got an error:
Creating snapshot ALL_LOGS and it indexes....
from field, hole, activity, service, sequence, tape, unique_logs t,
activity_parameter
*
ERROR at line 30:
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_IREFRESH" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_REFRESH", line 83
ORA-06512: at "SYS.DBMS_REFRESH", line 62
ORA-06512: at "SYS.DBMS_ISNAPSHOT", line 76
ORA-01403: no data found
Creating snapshot ALL_LOGS and it indexes....
from field, hole, activity, service, sequence, tape, unique_logs t,
activity_parameter
*
ERROR at line 30:
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_IREFRESH" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_REFRESH", line 83
ORA-06512: at "SYS.DBMS_REFRESH", line 62
ORA-06512: at "SYS.DBMS_ISNAPSHOT", line 76
ORA-01403: no data found