RE: GoldenGate and foreign keys

From: Terrian, Thomas J DLA CTR INFORMATION OPERATIONS <Tom.Terrian.ctr_at_dla.mil>
Date: Fri, 30 Oct 2015 18:52:11 +0000
Message-ID: <EC0CCA09F117ED43ACBDEEF40E0BB4944636248A_at_HL01DAG4MB1.DIR.AD.DLA.MIL>

The logic is that we are migrating from Advanced Rep to GoldenGate. We have the current Advanced Rep schema (Schema1) and the new GoldenGate schema (Schema2). We cannot migrate in mass so we are migrating groups of tables from Schema1 to Schema2. So, for a short while we will have some tables in Schema2 with foreign keys back to Schema1. In the end, everything will be in Schema2.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mladen Gogala Sent: Friday, October 30, 2015 2:46 PM
To: oracle-l_at_freelists.org
Subject: Re: GoldenGate and foreign keys

On 10/30/2015 01:31 PM, Terrian, Thomas J DLA CTR INFORMATION OPERATIONS wrote:
> Does anyone know anything about GoldenGate (12.1.2.1)? Here is my question:
>
> Schema1.table1 has a primary key and Schema2.table2 has a foreign key back to Schema1.table1.
>
> Can I put Schema2.table2 in an extract without Schema1.table1 in the extract?
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>

Hi Thomas,
Yes, you can do it, if the same foreign keys are not present on the destination. Other than that, circular foreign keys are a little bit strange to me. What was the logic behind creating such constraints?

--
Mladen Gogala
Oracle DBA
http://mgogala.freehostia.com

--
http://www.freelists.org/webpage/oracle-l




--
http://www.freelists.org/webpage/oracle-l

Received on Fri Oct 30 2015 - 19:52:11 CET