---------------------------- Original Message ----------------------------
Subject:
From: [Email Address Removed] Tue, July 4, 2006 10:55 am
To: [Email address protected]
--------------------------------------------------------------------------

Dear haroon,

Assalam walikum,

Scenario
========
Now db1 server: MS SQL Server 2000 (master site)

and db2 server Oracle 9i R2 on separate machine


db2 oracle server is connected to db1 sql server 2000, by using
heterogeneous service

Problem
=======
SQL> create materialized view employee_mv
2 build immediate
3 refresh force on commit
4 disable query rewrite
5 as
6 select * from [Email Address Removed] * from [Email Address Removed] *
ERROR at line 6:
ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized
view

Please suggest any solution for above error or suggest alternative solution.

Nabeel Ahmed
[Email address protected]



Oracle LazyDBA home page