OraFAQ Forum: Replication » refresh data on target database...everytime there is data change at the source database

Home » Server Options » Replication » refresh data on target database...everytime there is data change at the source database (Oracle 12C database)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

refresh data on target database...everytime there is data change at the source database [message #665529]

Fri, 08 September 2017 12:47

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.

Report message to a moderator

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

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What about standby database or Streams?

Report message to a moderator

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

John Watson
Messages: 8977
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.

Report message to a moderator

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

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

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 20 19:38:45 CDT 2025