Snapshot Materialized view : how to ?

Hi

I'm a bit lost with snapshot creation, so can I have an easy (but with all details : *.ora, user grants, *.sql, db links, ...) example of snapshot between :

Server1 :
  instance : I1
  oracle user : user1
  table : user1.table1

Server2 :
  instance : I2
  oracle user : user2
  snapshot : user2.table1 as select * from user1.table1;

Thank you for your examples.

Bernard
bsegonnes_at_free.fr
http://bsegonnes.free.fr Received on Thu Jan 22 2004 - 08:18:11 CST