3 Replies Latest reply: Oct 4, 2012 3:28 PM by Mark Malakanov (user11181920) RSS

    Move data from Physical StandBy to Datawarehouse

    User392774
      Hi,

      We have this archicture:

      OLPT DB --> OLPT DB (Physical Standby, active dataguard) --> Data warehouse DB

      We only allowed to connect to OLPT DB (Physical Standby, active dataguard) from Data warehouse DB. If there is possibility to use some of Oracle "native" method of data extraction (replication) from OLPT DB (Physical Standby, active dataguard) to Data warehouse DB.

      As far as I know we cannot create materialized view log in OLPT DB (Physical Standby, active dataguard) in order to do data replication, but maybe there is some others ways?

      Thank you.

      Edited by: 919758 on 2012.10.1 01.05