materializd view

[premkumarsp1]

hi

i created a materialized view on a table prem to a remote database thru db link.

create materialized view prem
BUILD IMMEDIATE
refresh fast
start with sysdate
next sysdate +(1/1440)
as
select * from prem@dblink;

i created indexes on prem table in both databases. I created materialized view log in master table database.

I gave refresh time as 1 min. I inserted 6 records at a time. it is taking too long time more than 10 min to get replicated.
Wat is the problem. Can someone suggest me some solution.

thanks in advance..

[debasisdas]

That might be because of using the DBLINK.

[amitpatel66]

You can also rREFRESH the Materialized view using DBMS_MVIEW package by giving a call to REFRESH procedure

[subashsavji]

hi

i created a materialized view on a table prem to a remote database thru db link.

create materialized view prem
BUILD IMMEDIATE
refresh fast
start with sysdate
next sysdate +(1/1440)
as
select * from prem@dblink;

i created indexes on prem table in both databases. I created materialized view log in master table database.

I gave refresh time as 1 min. I inserted 6 records at a time. it is taking too long time more than 10 min to get replicated.
Wat is the problem. Can someone suggest me some solution.

thanks in advance..

try to use this option

refresh fast ON COMMIT ,
START WITH SYSDATE

other it may be the problem of O.S.