How to do FastRefresh of updateble Snapshots

From: MTa97 <Michael.Tapal_at_t-online.de>
Date: 13 Oct 1998 08:20:43 GMT
Message-ID: <6vv2gr$dd0$1@news00.btx.dtag.de>

HELP! trying to do replication on a particular table in Master-Snapshot-site mode.

MasterSite (the only): ORACLE 7.3.4.0
SnapShotSite(s): ORACLE 8.0.4

(README.DOC) Updatable Oracle 8 snapshots can have masters on Oracle 7.3.3 and above.

i've found bug 474694:

When a configuration involves any 7.x databases, always set min_communication=false

OK: I created the used replication group on this base (set min_communication=false).

Very well; but

Is it possible to use fast refresh for this snapshot ?????

I've got the following error creating snapshot refresh group with "use fast refresh" set to yes:

select distinct master, decode(substr(primary_key,0,1),'Y',1,0) from sys.dba_snapshot_logs<@DATABASELINK>
where master = ............
and log_owner = ............

/*****

ORA-00904: invalid column name

*****/

The View DBA_SNAPSHOT_LOGS at the MasterSite (7.3.4) does not have a column "PRIMARY KEY" What I have to do to archive fast refresh ??

thanks Received on Tue Oct 13 1998 - 03:20:43 CDT