All,
I am creating a Materialized view using joining of two tables. When trying for the FAST refresh, getting the message
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 linkCode: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
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


Reply With Quote
Bookmarks