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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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,054 views