| Replication with fast refresh [message #251142] |
Thu, 12 July 2007 08:39  |
vicentemaia
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 9.0.1.1.1 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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
