Skip to Main Content

SQL Developer

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

663305Oct 3 2008 — edited Oct 8 2008
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.
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 5 2008
Added on Oct 3 2008
1 comment