Problems with snapshot log

From: <redenm_at_my-deja.com>
Date: Tue, 02 Jan 2001 18:09:37 GMT
Message-ID: <92t5gq$8qq$1@nnrp1.deja.com>

I saw Michael's email regarding problems with snapshots. I have a problem which is similar but not quite. Here's my situation:

I'm using Oracle 8i Lite Ver. 8.0.5.0.1, having a master DB used for replication. I manually updated (deleted old records, inserted new records) one of the tables. When I did a fast refresh (via application), I'm getting the following message:

REPAPI-26515: no master log available for PMPTST.TBL_AFFILIATE.

I tracked down this error and it points me to MLOG$_TBL_AFFILIATE which was missing. I manually (via SQL Plus) re-created said snapshot log and re-tested fast refresh, same error message. Question: does this table updates itself when there are changes (deleted old records, inserted new records) on the master table (TBL_AFFILIATE)? If not, do I need to consider updating (deleted old records, inserted new records) this snapshot log table (via SQL Plus)? I'm new to Oracle replication and appreciates any help on this. Thanks.

Sent via Deja.com
http://www.deja.com/ Received on Tue Jan 02 2001 - 12:09:37 CST