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 <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
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
Posting Permissions
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
Forum Rules
Click Here to Expand Forum to Full Width
Bookmarks