5 Replies Latest reply on Sep 4, 2012 2:36 PM by Kgronau-Oracle

    Oracle Gateway plus materialized view

    Miled Moukhtafi
      Dear Sir,

      we have microsoft sql server, oracle gateway server (11G) and database server (

      we already make the full setup, and it's working.

      we create materialized view into oracle server to read a data from sql server, but the refresh of MV take long time so
      we are planing to create the materialized view into oracle gateway server.

      my question is:

      what is the best solution to create MV into oracle gateway server?!!
      i mean i don't want to download oracle database instance for only one MV.

      thanks in advanced.