M. View Fast Refresh
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: M. View Fast Refresh

Threaded View

  1. #1
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727

    M. View Fast Refresh

    All,

    I am creating a Materialized view using joining of two tables. When trying for the FAST refresh, getting the message

    Code:
    SQL> exec dbms_mview.refresh('crew_log','F');
    BEGIN dbms_mview.refresh('crew_log','F'); END;
    
    *
    ERROR at line 1:
    ORA-12004: REFRESH FAST cannot be used for materialized view
    "REPLDBA"."CREW_LOG"
    ORA-06512: at "SYS.DBMS_SNAPSHOT", line 794
    ORA-06512: at "SYS.DBMS_SNAPSHOT", line 851
    ORA-06512: at "SYS.DBMS_SNAPSHOT", line 832
    ORA-06512: at line 1
    Originally my understanding was, FAST refresh is not possible on M. Views based complex queries ( M. Views with joins and functions). But please see the following link

    http://www.oracle.com/technology//pr...ily/jul05.html

    I have Oracle 9.2.0 in both ends and the OS is IBM AIX. M. View logs as well created. If the above link is true, why I am getting the problem?

    Many Thanks
    Last edited by Thomasps; 08-05-2004 at 04:54 AM.
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

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