Home » SQL & PL/SQL » SQL & PL/SQL » ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view
ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view [message #189699] Fri, 25 August 2006 12:39 Go to next message
grk28
Messages: 38
Registered: June 2006
Member
Hi frnds,

I have created a snapshot and have given the
REFRESH ON COMMIT OPTION for the same,but while creating the view i am getting the following error

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

I would like to know when we will be getting the error and what is the solution to avoid this.I have gone through few forums but was bit confused.

Immediate help would be appreciated.

Thanks in Advance,
GRK

Re: ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view [message #189808 is a reply to message #189699] Sun, 27 August 2006 23:48 Go to previous message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Use DBMS_MVIEW.EXPLAIN_MVIEW to determine the Fast Refresh capabilities of the MV.

If you don't understand the output of EXPLAIN_MVIEW, post it here.

Ross Leishman
Previous Topic: Settings before Login
Next Topic: index question
Goto Forum:
  


Current Time: Sun Dec 04 22:55:39 CST 2016

Total time taken to generate the page: 0.11342 seconds