- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-01-2025 05:20 AM
We are planning to configure Instance Data Replication between prod and two lower instances to syncronize user data from prod to lower instances.
Please confirm on below questions:-
1 . Instance Data Replication is applicable to sys_user table ?
2. is Instance Data Replication only work for insertion or insertion/update both in realtime
3.assoicate reference tables such as cmn_location, how Instance Data Replication will handle that ?
Please let us know so we can plan accordingly
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-01-2025 05:32 AM
1. no (see official docs, link below)
2. both
3. you will need to replicate the referenced data as well
Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-01-2025 05:26 AM
Hi @sachinmishr ,
1 . Instance Data Replication is applicable to sys_user table ?
yes, it works on sys_user table and almost all the tables
2. is Instance Data Replication only work for insertion or insertion/update both in realtime
it works for both insert and update (also can work one directional and bi directionally)
3.assoicate reference tables such as cmn_location, how Instance Data Replication will handle that ?
you will have to synch those tables as well
Please mark my answer as helpful/correct if it resolves your query.
Regards,
Chaitanya
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-01-2025 05:32 AM
1. no (see official docs, link below)
2. both
3. you will need to replicate the referenced data as well
Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark