Foreign Keys in a Cycle

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.

CQuill April 06, 2017 21:04

Comments

1 comment

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

Eddie D April 11, 2017 11:24

0

Add comment

Please sign in to leave a comment.

How can we help you today?

Foreign Keys in a Cycle

Comments

Add comment