Home » Server Options » Replication » refresh data on target database...everytime there is data change at the source database (Oracle 12C database)
refresh data on target database...everytime there is data change at the source database [message #665529] Fri, 08 September 2017 12:47 Go to previous message
philipebe
Messages: 19
Registered: September 2017
Junior Member
Hi,
We have a source database which is Oracle 12c that has lots of transaction tables. And we have a target database just for reporting purpose which is also same 12c version.
For not we use dblink to pull data into target database tables from the source database tables.
2 scenarios:
1. we want the target tables to be refreshed every hour, so we created MVs with refresh on every hour
or
2. We want this data refresh to happen at the target tables, every time data change happens at the source tables.
How do we do this? what are the different ways we can do this?
We are not looking to buy GoldenGate or any replication tools. But can we do the above need, with just sql, dblinks, scheduled jobs, or materialized views?
Thanks in advance.
 
Read Message
Read Message
Read Message
Read Message
Previous Topic: Replicate process is abended and getting integrity constraint error - ORA-02291
Next Topic: migrate to different Linux server and upgrade database from 12.1 CDB RAC to 12.2 non-CDB non-RAC
Goto Forum:
  


Current Time: Mon Jan 27 00:39:36 CST 2020