Description
We had a preliminary discussion with Pierre-Etienne of the Lyon DBA team.
Now we have to identify if there is one of the Oracle "data-replication" features that can be a good compromise in terms of efforts vs advantages.
At present we know about the existence of Oracle streams, Data Guard and materialized views.
Is one of them suitable for this use case?
Are there other possibilities?