Hello All,
Does materialized view offer real time data replication or it is near to real time replication?
My source and target db are different oracle db instances(2 different PDB within 2 different CDB at 2 different servers).
I heard/read that real time synchronization related provision introduced in Oracle12c , however want to get feedback if any one tried that.
More over is it only possible if db objects are part of same database or across different database instances?
Does it allow real time data replication through DB links.
How about on commit refresh? Does this refresh mechanism allow real time data replication across 2 different db instances or it is near to real time.
What leads to delay factor in case of on commit refresh strategy and that delay is upto seconds/minutes or up to hours in general and on average ( I understand it depends upon and specific to environment to environment and infrastructure setup , however still curious about general and most of cases in data warehousing and analytics era).
Thanks,
Rajneesh