Hi Every 1,


I have a question related to materialized views. I am using two Oracle 9i Servers. When I create the Materialized view MV1 on SERVER1 based on the table EMP1 on the same server SERVER1 and the Materialized view log on SERVER1 it works fine i.e., it refreshes automatically.

But when I create the Materialized View MV1 on SERVER1 based on the table EMP2 on SERVER2 and the Materialized view Log on SERVER2 on the Table EMP2, the Materialized view doesn't refresh automatically although it does refresh manually. (The Materialized view MV1 status indicated in the Enterprise manager is 'BROKEN').

Can any 1 inform me why the status is BROKEN and how do I overcome this problem. Your help will be highly appreciated.