Re: updateable snapshot

From: Frank <fvanbortel_at_netscape.net>
Date: Sat, 26 Apr 2003 19:46:49 +0200
Message-ID: <3EAAC609.3020202@netscape.net>

MC wrote:

> Frank <fvanbortel_at_netscape.net> wrote in message news:<3EA56F64.5040909_at_netscape.net>...
> 

>>MC wrote:
>>
>>>Hello everyone,
>>>
>>>Could somebody help me on the following issue...
>>>
>>>** Is updateable snapshot able to update master table?
>>>
>>>If yes then where is the problem that I do?
>>>
>>>
>>>I want to update master table thru the snapshot. Is it possible? Is it
>>>a bad work? Any clue would be appreciated?
>>>
>>>
>>>MC
>>
>>Where's the 'generate snapshot support' script?
>>Basically, you created a snapshot. Not an updateable replication
>>table

> 
> 
> Frank,
> I admit your statement. It is confused me because I used "CREATE
> SNAPSHOT ... FOR UPDATE.... " to build the snapshot and I wanted to
> update master table with that.
> 
> Thanks all
> 
> --MC

Still, you should have generated snapshot (or, as it is called today: materialized views) support on the master tables. There's some quite useful flow diagrams in the Replication Manuals - be sure to read both; the API as well. The examples work, and are pretty well documented (the API ones - the Replication Mnl just shows pictures of OEM... click here, drop there - and it turns out there's an undocumented call being made, that is absolutely needed)

In short: you can do what you want: create an updateable materialized view - I've done it for 150 clients, each having about thirty updateable mv's. One master, 150 snapshot sites.

-- 
Regards, Frank van Bortel

Received on Sat Apr 26 2003 - 12:46:49 CDT