Re: snapshot vs trigger

Mark Fontenot <mark_at_pickwick.com> wrote:

>jes_at_usa.pipeline.com(Johnnie Suggs) wrote:
>>as a new comer to the dba admin world...i have a question...
>>
>>i have a user who wants to update a seconday table when
>>a row is updated in a particular table. he knows he can
>>write a trigger..but...i was wondering if a snapshot wouldn't
>>be better?
>>
>>--
>>
>>Johnnie Suggs
 

>Until Oracle has worked out all of the bugs with snapshots, especially in
>FAST REFRESH mode, I'd stick to writing your own triggers and procedures
>for replicating.

What "bugs" are you referring to?

--
Chuck Hamilton
chuckh_at_ix.netcom.com

Incoming fire has the right of way!