Database DataWarehousing (MOSC)

MOSC Banner

ORA-04063: package body "SYS.DBMS_SNAPSHOT_UTL" has errors

edited Apr 16, 2013 11:17PM in Database DataWarehousing (MOSC) 8 commentsAnswered
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center