Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2563

user501676Apr 16 2013 — edited Apr 17 2013
Dear Team,
When i am monitoring my log file I am getting this below error often.Please suggest me how can i solve this issue.

ORA-12012: error on auto execute of job 224
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 15 2013
Added on Apr 16 2013
1 comment
2,875 views