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: 5
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: 65199
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 message
John Watson
Messages: 7148
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.
Previous Topic: DML operations not applying on target database
Next Topic: dbms_scheduler ORA-12560: TNS:protocol adapter error
Goto Forum:
  


Current Time: Mon Nov 20 22:39:56 CST 2017

Total time taken to generate the page: 0.06312 seconds