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.
Thank you.
Printable View
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.
Thank you.
create materialized view
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
PCTFREE 10
PCTUSED 40
MAXTRANS 255
TABLESPACE ts_medicamentos
STORAGE (
INITIAL 98304
NEXT 65536
PCTINCREASE 50
MINEXTENTS 1
MAXEXTENTS 121
)
PARALLEL (DEGREE DEFAULT)
REFRESH FORCE ON COMMIT
USING MASTER ROLLBACK SEGMENT RBS
local ROLLBACK SEGMENT RBS5
AS
select c.CLAVECENTRO,c.CODCENTRO
,c.DESCRIPCION
from centro c