I´m using materialized views, and I have a question : How I can refresh a materialized view with the commit of the remote table ??
I can refresh with a fixed time ( 5 min. for example), but I want to refresh my view every commit.
create materialized view <mv>
refresh complete on commit
enable query rewrite as
select acctnum, sum(bytes) bytes, count(bytes) c_bytes, count(*) from table1 group by acctnum;
This is my snapshot, but I can´t define it because :
ORA-12054: ON COMMIT refresh atribute for materialized view can´t be created.
CREATE SNAPSHOT developer.vw_centro2
PARALLEL (DEGREE DEFAULT)
REFRESH FORCE ON COMMIT
USING MASTER ROLLBACK SEGMENT RBS
local ROLLBACK SEGMENT RBS5
from centro c
Click Here to Expand Forum to Full Width