Makes great sense....thanks.
-----Original Message-----
From: Moizuddin Arshad Mohamed [mailto:moizarshad@xxxxxxxxx]
Sent: Saturday, October 31, 2015 10:16 PM
To: Terrian, Thomas J DLA CTR INFORMATION OPERATIONS
Cc: gogala.mladen@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: GoldenGate and foreign keys
Hi Terrain,
Yes, you can do it with Goldengate and treat each table separately independent.
But you would encounter parent-child issues later.
The idea is to replicate tables with dependents (parent-child) together in one
stream of replication so to avoid this issue.
If you are planning to do the replication in phases, probably better idea is to
combine dependent tables from both schema1 and schema2 and do it in phases.
Hope this helps.
Thanks,
Moiz
On Fri, Oct 30, 2015 at 1:52 PM, Terrian, Thomas J DLA CTR INFORMATION
OPERATIONS <Tom.Terrian.ctr@xxxxxxx> wrote:
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mladen Gogala
Sent: Friday, October 30, 2015 2:46 PM
To: oracle-l@xxxxxxxxxxxxx
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?
>
>
> --
> //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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
��i��0���zX���+�� n��{�+i�^
