| Pre-Requisites For Oracle Advanced Replication [message #664872] |
Wed, 09 August 2017 09:16  |
 |
WhiteWalker
Messages: 3
Registered: August 2017
|
Junior Member |
|
|
Hello Everyone,
Greetings.
I have a few questions regarding Oracle Advanced Replication -
i.) Do the database architectures need to be the same in terms of schemas, tables and table structures at all the master sites in case of multi-master replication?
ii.) What are the essential initial parameter settings for setting up a replication environment?
iii.) In master-materialized view environment, as per my understanding from reading the Oracle's Advanced Replication documents, each materialized view group at a materialized view site corresponds to a master group at the master site and each materialized view corresponds to a master table at the master site. Does it mean that we can only create materialized views based on a single table in a materialized view group?
iv.) In case there are two databases different in architectural organization, what should the approach for replication? For instance, currently I am administering synchronization between two database servers. One of the servers has multiple user defined schemas while the other one has a single user defined schema. The tables are nearly the same having some differences between the numbers, names and sizes of the columns. Currently I have created an intermediate schema at each of the database. In that intermediate schema at each database, I have created materialized views against the master tables at the other database. I have created procedures that detect the differences between the master tables and the corresponding materialized views and then write the data from the materialized view to the master tables. Currently we are working in an environment where the approach I am following does not lead to conflicts as one type of entry is being done at one single point. But from future perspectives, I am looking for a cleaner and a safer way.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
