Gateways, Oracle Lite, Oracle DB Mob. Server, TimesTen (MOSC)

MOSC Banner

Creating a materialized view based on SQL Server tables

 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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center