Home » Server Options » Replication » Replication questions
Replication questions [message #140962] Thu, 06 October 2005 07:28
Messages: 8
Registered: August 2005
Junior Member
Two questions about replication fo tables

1. If i replicate a table from database A to B and wants to have other tables referencing the MV in database B is that possible? What happens if the MV needs be refreshed completly? What happens with FK that are connected to the MV in database B?

2. I replicate table customer from databases A and B into C and the primary key consist of a number generated from a sequence. There is a possibility that the generated PK can be the same from database A and B. Is there any way to come around this problem (if I don't want to change the PK in database A and B)?

Previous Topic: Data Replication from DB2 to Oracle 10g
Next Topic: readonly mview setup problem
Goto Forum:

Current Time: Sat Dec 04 17:27:07 CST 2021