M. View Fast Refresh
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 link
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
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?
Last edited by Thomasps; 08-05-2004 at 04:54 AM.
Click Here to Expand Forum to Full Width