The snapshots in 8i are know as materialized views-Right. If that is so, then Oracle 8i standard edition does not support materialized views but supports basic replication- which is single master/multi snapshot/updatable snapshots etc.
I fail to understand, if the materialized views are not allowed in 8i, how does it create a snap shot.
10-18-2002, 03:59 PM
well I guess what is not available as Materialized View in standrd edition is it does not support Query Rewrite?
but if you are using MV as snapshots then you can work with it