Re: snapshots of remote views

joe_at_access1.digex.net (Joe Nardone) wrote:

>You're right. My mistake. However, to do fast refresh you have to
>install triggers on certain tables. (After-insert, I believe). However,
>because 7.0 only allows 1 type of trigger per table, if you already
>have after-insert (or after-update) triggers on your tables you're
>screwed as far as fast refresh goes.
 

>Joe

You just need to create snapshot logs on the base tables. Oracle creates the triggers itself.

--
Chuck Hamilton
chuckh_at_ix.netcom.com

Never share a foxhole with anyone braver than yourself!