5 Replies Latest reply: Sep 4, 2012 9:36 AM by Kgronau-Oracle RSS

    Oracle Gateway plus materialized view

    Miled Moukhtafi
      Dear Sir,

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

      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.