Dear All,

I want to create the Snapshot in oracle db 8.0, as before 8.x it was named as Snapshot and then to Materialized Views.

I have multiple schemas, and was looking to create the snapshot which will merge the data from all the schemas and generate the output.

So can any one give the step by step procedure for creating the same with refresh options.

Thanks in advance