Re: Urgent......Snapshot Refresh

Do you have a snapshot log on the other end ??? Oracle will probably do a complete refresh if it doesn't have snapshot logs (doesn't know what has been updated).So be sure you have 'em

Complete refresh=truncate&fill
Hope this helps

Art Groeneveld
Oracle Systems Designer

owais_anjum_at_my-deja.com wrote:

> Hello
> I am using Oracle 8 and am trying to implement readonly snapshots in a
> distributed environment. Both databases are Oracle 8 and the database
> links work fine.
>
> The first time I create the snapshot, it is perfectly updated. Any
> attempt to update the snapshot thereafter simply deletes all rows from
> the snapshot. Please see that I am refreshing the snapshot in FAST mode.
>
> Can anybody figure out the possible causes for this bahavior.
> Thanx in advance
>
> Owais
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Sun Jul 18 1999 - 21:52:41 CEST