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 next 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.
Re: refresh data on target database...everytime there is data change at the source database [message #665530 is a reply to message #665529] Fri, 08 September 2017 13:20 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

What about standby database or Streams?

Re: refresh data on target database...everytime there is data change at the source database [message #665539 is a reply to message #665529] Sat, 09 September 2017 03:01 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
There is a problem with all replication nowadays: Larry has desupported Advanced Replication in 12.2 and deprecated Streams in 12.1. Deprecation may not be a problem now (it is still supported) but in a future it won'i support any new features.
If you have Enterprise Edition licences your best option may be a logical standby database. Very versatile if configured appropriately.
Re: refresh data on target database...everytime there is data change at the source database [message #667585 is a reply to message #665539] Sat, 06 January 2018 21:37 Go to previous message
philipebe
Messages: 19
Registered: September 2017
Junior Member
Thanks for the responses.
For now we have a scheduler job setup that refreshes the data ever hour.
But have plans to setup MV refresh on data change
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: Thu Mar 28 06:54:53 CDT 2024