| 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.
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
