By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,278 Members | 2,358 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,278 IT Pros & Developers. It's quick & easy.

Problem in Materialized view

P: 1
I created a materialized view log on table DUMMY_TAB as shown below:

create materialized view log on DUMMY_TAB with primary key including new values;

Primary key for the table DUMMY_TAB is trans_id.In this table if any date is added i want to refresh the materialized view.

Then i created materialized view on table DUMMY_TAB as follows:

create materialized view temp_view
build immediate
refresh fast
enable query rewrite as
SELECT ID, nvl2(MAX(CRE_DATE),MAX(CRE_DATE),MAX(TXN_DATE)) AS LAST_TXN_DT
from DUMMY_TAB group by ID

I got the errror:

ORA_12054:Cannot set the ON COMMIT refresh attribute for the materialized view.Can anyone help me how to resolve this error??
Aug 29 '08 #1
Share this Question
Share on Google+
2 Replies


amitpatel66
Expert 100+
P: 2,367
Please let us know which oracle version you are using??
Aug 29 '08 #2

P: 6
read the link below


link
Mar 1 '10 #3

Post your reply

Sign in to post your reply or Sign up for a free account.