-
Materialized view refresh
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
-
are you perhaps refreshing this MVIEW from a remote database?
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|