Constraints Error on v8

From: M. Bhatti <mohammed.bhatti_at_mci.com>
Date: Fri, 18 Dec 1998 20:17:25 GMT
Message-ID: <367AB827.7C65FE74@mci.com>

This is for an Oracle8 (8.0.4.0.0) Sun Solaris 2.5.1

Recently migrated this db from v7.3.2.0.0 to 8.0.4.0.0 using th mig utility.

Created all the tables. Now, when I try and create some creates eg ALTER TABLE
PSP_ADDR
ADD CONSTRAINT
PSP_ADDR_FK1 FOREIGN KEY (state_cd)
REFERENCES STATE (state_cd)
;
I get ORA-02270: no matching unique or primary key for this column-list.

Well, the STATE table does have a PK on state_cd (I've checked in the dba_% views and it's there). In both tables, state_cd is not null char(2). I've dropped the tables/indexes and re-created them and tried the above again. Nothing. I am able create the above in a Oracle7.3 db and it works.

Also, I can't create any FK constraints (PK and others are OK). On the same machine, I have another v8 db but I have the same problem - so probably not a corrupt dictionary.

So, anyone come across this before? Ideas?

Thanks

mkb Received on Fri Dec 18 1998 - 14:17:25 CST