After upgrading to 10g, we are getting the following error.
BEGIN
dbms_refresh.REFRESH('REFGRP_PROFILE_MV_CEEMEA');
END;
Gives the following error
ORA-12048: error encountered while refreshing materialized view "CRI_CEEMEA_ADMIN"."USER_ROLE_TITLE"
ORA-02068: following severe error from CEEMEA_DBLINK_CRI
ORA-03113: end-of-file on communication channel
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2255
ORA-06512: at "SYS.DBMS_SNAPSHOT", line
BEGIN
dbms_mview.REFRESH('USER_ROLE_TITLE');
END;
Gives the following error
ORA-12008: error in materialized view refresh path
ORA-02068: following severe error from CEEMEA_DBLINK_CRI
ORA-03113: end-of-file on communication channel
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2255
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2461
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2430
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Reply With Quote
Bookmarks