Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: "Writeable" Snapshots ??
The concept was never well documented, but all you needed to do (at least in v7) was to create a snapshot and add the "for update" clause at the end of the create command. I checked a v8.1 manual and the "for update" clause is still valid. In v7 the trigger to send stuff back up to the master was only created if the snapshot was registered with the replication catalog and someone generated replication support for it. If you didn't do that, you ended up with a "writeable" snapshot. I'm guessing it works the same way in v8.1
"AtlDBA" <sar30329_at_my-deja.com> wrote in message
news:8pit2s$gs1$1_at_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 Sat Sep 16 2000 - 11:14:44 CDT