q: read-only snapshot replication

When fast refresh is used, how does Oracle determined what data to replicate? If a value is changed by an end use from "foo" to "foo" is the Oracle replication machinery smart enough to know that the data is the same and therefore and update should not be sent over the wire? In other words, does Oracle simply keep a last modified date for each data item or is there also some sort of checksum taking place on the data itself?

With read-only snapshot replication, is it possible to replicate a view? Is there an effective way to replicate a table that gets dropped/recreated on a nightly basis even though most of the data remains the same?

Thanks.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Dec 23 1999 - 09:49:19 CST