var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized
- When I create Materialized View:
CREATE MATERIALIZED VIEW "MVADMIN"."DMBANGCAP"
SELECT BCMA AS MABANGCAP, BCTEN AS TENBANGCAP FROM HOSOCANBO.BANGCAP@NDLINH
I meet error like this:
ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized
I has granted ON COMMIT REFRESH privilege to MVADMIN.
Please help me
You can't refresh a materialized view ON COMMIT when it selects across a dblink. Your database doesn't know about commits taking place in the remote database.
You would need to look at Advanced Replication to achieve this.