Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Help
If you really mean that the table has 2 Primary Key constraints, then there is a problem: a table can only have 1 PK ( hence, Primary)
"Jay" <jay_kingston_at_hotmail.com> wrote:
>I am trying to generate tables in Oracle Designer but I keep getting the
>following Error Message:
>
>ORA-02267 column type incompatible with referenced column type
>
>The table in question only has 2 primary key fields which are referenced on
>2 other tables. All the datatypes are Number and the lengths match up. I
>have tried Oracles' knowledge base and help files but still the error hasn't
>been resolved. Does anyone know how to resolve this error. Thanx.
>
>
-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! Check out our new Unlimited Server. No Download or Time Limits! -----== Over 80,000 Newsgroups - 19 Different Servers! ==----- Received on Fri Aug 24 2001 - 15:15:42 CDT