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
    Bangalore, India

    M. View Fast Refresh


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

    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
    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


    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)


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