I have 2 simple table which has columns like :
table1 :
- "OBJECTID" NUMBER NOT NULL ENABLE
- "OLCEK_ID" NUMBER(*,0)
table2 :
- "OBJECTID" NUMBER NOT NULL ENABLE
i created materialized log view as below :
CREATE MATERIALIZED VIEW LOG ON table1
WITH ROWID(OBJECTID,olcek_id), SEQUENCE
INCLUDING NEW VALUES;
CREATE MATERIALIZED VIEW LOG ON table2
WITH ROWID(OBJECTID), SEQUENCE
INCLUDING NEW VALUES;
And when creating materialized view i got an error : ORA-12015: cannot create a fast refresh materialized view from a complex query.
CREATE MATERIALIZED VIEW "PUBLIC"."TEST_MV"
REFRESH FAST
AS SELECT a.OLCEK_ID
FROM TABLE1 a join TABLE2 ko ON a.OLCEK_ID= ko.OBJECTID;
I'm struggling to understand which part of my view is complex. Offical docs have example with joins.