This discussion is archived
3 Replies Latest reply: Oct 4, 2012 1:28 PM by Mark Malakanov (user11181920) RSS

Move data from Physical StandBy to Datawarehouse

user392774 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points