Competition: What’s your favorite Redgate tool? Enter now.

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.

Comments

Sign In or Register to comment.