Creating a materialized view based on SQL Server tables
edited Dec 2, 2013 6:08AM in Gateways, Oracle Lite, Oracle DB Mob. Server, TimesTen (MOSC) 1 commentAnswered
Hi,
I have been looking into this problem for a couple of days now and I was wondering if anyone has done what I am trying to do.
I have an Oracle database 11.2.0.1 with a gateway connection (DG4ODBC) to SQL Server. For performance I am looking to transfer data into Oracle in the form of Materialized views to perform aggregations. This will be an on demand user operation.
However, when I try and create a Materialized view using the REFRESH FAST to only obtain incremental updates it fails with the error - ORA-12015: cannot create a fast refresh materialized view from a complex query.
0