Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized

252122Jan 16 2007 — edited Jan 20 2007

This problem seems strange. I tried to create materialized view like following:

DROP MATERIALIZED VIEW sample_case_mv;

CREATE MATERIALIZED VIEW sample_case_mv
BUILD IMMEDIATE REFRESH FAST on commit enable query rewrite
AS select count(*) from sample se, allele_map alp where alp.sample_id(+)=se.id

It gave me ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized .

If I take off outer join as where alp.sample_id=se.id, then mview can be created. What is wrong to have outer join in WHERE clause?

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 17 2007

Added on Jan 16 2007

#general-database-discussions

7 comments

5,501 views