Last updated on FEBRUARY 02, 2017
Applies to:Oracle Server - Enterprise Edition - Version: 184.108.40.206
Information in this document applies to any platform.
While trying to create a fast refresh materialized view using two tables, receive error.
SQL> create materialized view test_mv refresh fast as select t.rowid abc,s.rowid def,t.a,s.e,s.f from Product t,Dispatch s where t.c=s.f;
create materialized view test_mv refresh fast as select t.rowid abc,s.rowid def,t.a,s.e,s.f from time t,time_scn s where t.c=s.f
ERROR at line 1:
ORA-32414: materialized view logs are not compatible with each other for fast refresh
Using Commit SCN-based materialized view log for one table.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms