Forum Stats

  • 3,872,090 Users
  • 2,266,378 Discussions


1.5.1 MS Access migration: different type relationships to constraints BUG?

663305 Member Posts: 1
edited Oct 8, 2008 8:14AM in SQL Developer
MS Access allows for relationships (key/foreignkey) between tables on columns of a different datatype.

It seems the access migration tool is translating these relationships to Oracle constraints in the target DDL script. This results in an error when the DDL is executed: ORA-02267: column type incompatible with referenced column type.

Quick migrate will fail too ofcourse.

Workaround is to edit the DDL by hand and delete the constraint statements or to remove the relationship from MS-Access.

It should be possible for the Access exporter to skip generating a constraint for these different-type relationships.


This discussion has been closed.