Re: GoldenGate and foreign keys

the purpose of putting parent-child table in same extract is to ensure the transaction order is considered in the destination, of course you can seperate them but if one replicat is slower than other you might get parent key not found when inserting child tables

not sure if I have understood fully your question :-?

On Fri, Oct 30, 2015 at 6:31 PM, Terrian, Thomas J DLA CTR INFORMATION OPERATIONS <Tom.Terrian.ctr_at_dla.mil> 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
>
>
>

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