Skip to Main Content
Forums

Oracle Database Discussions

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-12008: error in materialized view refresh path

sweetritzJul 8 2014 — edited Jul 9 2014

Hi DBAs,

I am a newbie DBA and while doing daily health check found the below errors.

ORA-12012: error on auto execute of job 576872

~ORA-12008: error in materialized view refresh path

~ORA-00980: synonym translation is no longer valid

~ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2256

~ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2462

~ORA-06512: at "SYS.DBMS_IREFRESH", line 685

~ORA-06512: at "SYS.DBMS_REFRESH", line 195

~ORA-06512: at line 1

now I can only understand that error occurred in some materialized view refresh job.

Any help to dig down the issue and with some solution for the same?

regards,

Ritu
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 6 2014
Added on Jul 8 2014
#general-database-discussions, #oracle
14 comments
8,461 views