"Writeable" Snapshots ??

From: AtlDBA <sar30329_at_my-deja.com>
Date: Mon, 11 Sep 2000 15:18:12 GMT
Message-ID: <8pit2s$gs1$1@nnrp1.deja.com>

Oracle used to mention the concept of "writeable" snapshots in version 7. In other words, a writeable snapshot was basically a snapshot which could be updated at the target end, but the updates would NOT be propagated back to the master. I have the need for something similar now using Oracle 8.1.5, but not sure how to implement it. It appears that I could create an updateable snapshot and then just disable the trigger at the target end so updates won't get put into the deferred transaction queue and ultimately back to the master.

I'm just wondering if anyone can clarify this for me. The replication documentation doesn't really address this clearly.

Thanks!

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Sep 11 2000 - 10:18:12 CDT