The concept definitly works over a database link. Since this is a test environment, I would:
1. insert some data on the master site
2. check both the master and the mview for the new data (should only be at the master)
3. perform my fast refresh
4. check mview for the new data.




Reply With Quote