Materialized view refresh
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Materialized view refresh

  1. #1
    Join Date
    May 2006
    Posts
    8

    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

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    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
  •  



Click Here to Expand Forum to Full Width