Home » Server Options » Replication » Replication with fast refresh
Replication with fast refresh [message #251142] Thu, 12 July 2007 08:39 Go to next message
Messages: 1
Registered: July 2007
Junior Member
hi everybody,
I have a problem in replication with fast refresh. I used 2 Windows 2000 server with Oracle 9i Release and I can't made the automatic atualization. This doesn't work and I cant use ON DEMAND.
I made

Remote server
Create table teste (a number primary key, b varchar2(20));

insert into teste (a, b) values (1, 'weqwuqeui');

create materialized view log on teste with primary key;

Server Local --------
create materialized view admin.teste_mv
build immediate
refresh fast start with sysdate next sysdate + 1/1440
with primary key as
select * from teste@servidor1;

Server Remoto -------
insert into teste (a, b) values (2, 'qwerty');

The first line is in the materialized view teste_mv but the second never appear.
I know it's a dumb trick but I can't solve this problem at the moment.
If somebody can help I would appreciate.
Thanks in advance
Re: Replication with fast refresh [message #260314 is a reply to message #251142] Sat, 18 August 2007 05:40 Go to previous message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
Have a look at the data of the table USER_MVIEW_REFRESH_TIMES.

I hope you have issued commit after the insertion of the second row. Cool

Previous Topic: 10g R2 Advanced Replication documentation (renamed by LF)
Next Topic: Replication from Oracle to Sybase
Goto Forum:

Current Time: Sun Aug 14 09:51:40 CDT 2022