Snapshot site replication

From: Grant Eggleton <grant.eggleton_at_isspl.com.au>
Date: Mon, 20 Dec 1999 13:20:52 +0800
Message-ID: <385dbdde.0@news.highway1.com.au>

Is there any simple reason, or place where I can find a reason why my snapshots do not automatically update.

On the master site I have created a snapshot log and the remote site has created the database link and the snapshot in the following manner:

CREATE SNAPSHOT ISS_PRS_USER
PCTFREE 5 PCTUSED 40
TABLESPACE IPRS
STORAGE (INITIAL 1024K NEXT 2048K PCTINCREASE 50) REFRESH FAST
START WITH sysdate
NEXT sysdate + 5/(60*24)
AS SELECT * FROM ISS_PRS_USER_at_PRS_PTH; The creation of the SNAP$_ table works fine and contains the data, although the table is not updated with the snapshot log details every 5 minutes.

The JOB_QUEUE_PROCESSES is equal to 3 in both init files. Received on Sun Dec 19 1999 - 23:20:52 CST