Replication Fast Refresh

[vicentemaia]

Hello everybody.
I have a problem in Fast Refresh replication. I created a replication on two Windows 2000 servers with Oracle 9i Release 9.0.1.1.1 and I can not make the updates automatically occur in the interval defined in the Next parameter. Simply does not update. I can not use manual update in this case.
I made the following steps in each of the servers.

remote server -------

Select all

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;

Local Server --------

Select all

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;

Remote Server -------

Select all

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

The first line appears in the materialized view test_mv but the second line never appears.
I know it must be a stupidly simple thing but is not updating. If anyone could give me a tip of what is wrong would appreciate a lot.
A hug

[gilbertoca]

I'm sorry Vicente, it looks like this is a matter advancing!

I have little experience and I have not had the opportunity to use this feature.

I'm kicking here: Have you ever performed this query outside
Materialized View? And does it work with the updates made?

Gilberto

[vicentemaia]

Gilberto,
works yes, all structures, links everything is right. The problem, I believe, is in configuring Oracle to perform these update tasks in the background. I have not yet come to a conclusion but I will arrive.
Thanks for the attention.
a hug

Vicente

[dr_gori]

I do not know if it is your case, but I found the following: http://www.cit.uws.edu.au/docs/oracle/e ... iewbug.php

Enterprise Database: Materialized View Refresh Bug
Materialized View Refresh Bug
Please note that the Two Oracle 9i Databases (ORA9EDB1 and ORA9EDB2) Setup for Enterprise Database Do Not Ape to Be Automatically Performing Materialized View Refreshes. The Work Arounbd for this is to run The Following Statement to Manually Perform MaterialIsed View Refresh:

Select all

      EXECUTE DBMS_MVIEW.REFRESH([VIEW],[REFRESH TYPE]); 

For example, to Fast Refresh on the MaterialIged View Empview, You Would Issue The Command:

Select all

      EXECUTE DBMS_MVIEW.REFRESH('EMPVIEW','F'); 

I Hope This Helps You in Your Tutorials and Assignment!

CIT DBA 2004-05-17

Maybe have something in Metalink about it.

[Diego Bilhalva]

Select all

create materialized view admin.teste_mv  
[tablespece] [nome da tablespace] 
refresh fast 
with primary key 
next (sysdate + 1/1440) 
as  
select * from teste@servidor1;

I hope it works!

[ruevers]

Friend, makes refresh manual, as I say in the post above, more guaranteed.

[Bruno]

I believe that Refresh is not being done because Refresh FAST updates MaterialIged View based on the logging of the updates in the source table. Therefore, you need to create MaterialIged View Log in the data table and your respective access permissions. And from then on, when the Fast Refresh is given it will update the materialized view only with the log data that has not yet been updated.

Ex: Create materialized view log on test;