Oracle Snapshot (materialized views) - WHERE clause on another table (ORA-12015)
Posted on 2005-03-16
is it possible to make a snapshot including a WHERE clause naming another table.
CREATE MATERIALIZED VIEW A
START WITH TO_DATE('17-MAR-2005','dd-mon-yyyy')
NEXT TRUNC(SYSDATE + 1)
WITH PRIMARY KEY
FROM a, b
WHERE a.numcpt = b.numcpt
AND B.typcpt = 'X'
I have this error :
ORA-12015: cannot create a fast refresh materialized view from a complex query
Can I avoid this problem or is it really impossible.
I work in oracle 188.8.131.52.
Thanks a lot