ORA-04063: package body "SYS.DBMS_SNAPSHOT_UTL" has errors
Dear Team, while access the users below are the error showing in the alert log.User not able to continue the work and i can't able to create new materialize views.Please suggest me as soon as possible.
ORA-12012: error on auto execute of job 244
ORA-04063: package body "SYS.DBMS_SNAPSHOT_UTL" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SNAPSHOT_UTL"
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2563
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2776
ORA-06512: at "SYS.DBMS_IREFRESH", line 685
ORA-06512: at "SYS.DBMS_REFRESH", line 195
ORA-06512: at line 1
ORA-12012: error on auto execute of job 244
ORA-04063: package body "SYS.DBMS_SNAPSHOT_UTL" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SNAPSHOT_UTL"
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2563
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2776
ORA-06512: at "SYS.DBMS_IREFRESH", line 685
ORA-06512: at "SYS.DBMS_REFRESH", line 195
ORA-06512: at line 1
0