I have encountered a problem while carrying out Oracle replication. My source/master database is Oracle 8.1.7.0.4 and target database is Oracle 9.2.0.4. When the “create snapshot” was in progess on the target database side some updates had occured on the master tables on the source.It was found that the changes to the master tables during the phase when the snapshot had been created had not been propagated to the target site.
Could anyone explain the anomaly and point out the possible remedies?? Through OEM, a complete refresh was made to propagate the changes to the target site,but I would like to go for a permanent solution without going into OEM.
The “create snapshot” script used is as follows…
CREATE SNAPSHOT ACCOUNT
TABLESPACE LARGE_TS_01
INITRANS 1 MAXTRANS 255
NOLOGGING
REFRESH FAST
NEXT sysdate + 2/(24*60)
with rowid
as
select * from MASTER.ACCOUNT@DEV2.WORLD;
ALTER SNAPSHOT ACCOUNT LOGGING;