Foreign Keys in a Cycle

CQuill

I'm trying to compare data in two different databases using Data Compare for Oracle v 2.6.6.1609.

Whenever I try I'm getting the following error:

Your database contains tables that are connected by foreign keys in a cycle. Data cannot be inserted as one of these constraints will violated. To allow the data to be inserted please break the cycle by disabling one of the foreign keys.

There is one table in the schema that has a FK to another column on the table but I have removed that table from the project scope. I am, however, still receiving the error.

Any suggestions on how to correct this issue?

Thanks.

Eddie D

Hi, thank you for your Forum Post.

If you increase the minimum logging level to verbose as per the instructions in this help article:
https://documentation.red-gate.com/display/DCO2/Logging+and+log+files

Is there any information in the log file as to the tables in the circular dependency?

Many Thanks
Eddie