ORA-02270: no matching unique or primary key for this column-list

Hello All. I've ran into this problem and can't seem to get past it. I've checked over the table structures more than a few times without any answers. The rest of the foreign keys seemed to work under the same circumstances.

Parent table:

LOGIN_GROUPS

Child Tables:

LOGIN_GROUP_MENU_GRANTS

USER_GROUPS

Primary Key Definitions:

LOGIN_GROUPS: GROUP_KEY

LOGIN_GROUP_MENU_GRANTS: LG_GROUP_KEY, SM_NODE_KEY

USER_GROUPS: LG_GROUP_KEY, USR_LOGIN

SQL> PROMPT CREATING USLG_LGG_FK

CREATING USLG_LGG_FK

SQL> ALTER TABLE USER_GROUPS ADD(

2 CONSTRAINT USLG_LGG_FK

3 FOREIGN KEY (LG_GROUP_KEY)

4 REFERENCES LOGIN_GROUPS (GROUP_KEY));

REFERENCES LOGIN_GROUPS (GROUP_KEY))

*

ERROR at line 4:

ORA-02270: no matching unique or primary key for this column-list

SQL>

SQL> PROMPT

SQL> PROMPT

SQL> PROMPT CREATING LGMG_LGG_FK

CREATING LGMG_LGG_FK

SQL> ALTER TABLE LOGIN_GROUP_MENU_GRANTS ADD(

2 CONSTRAINT LGMG_LGG_FK

3 FOREIGN KEY (LG_GROUP_KEY)

4 REFERENCES LOGIN_GROUPS (GROUP_KEY));

REFERENCES LOGIN_GROUPS (GROUP_KEY))

*

ERROR at line 4:

ORA-02270: no matching unique or primary key for this column-list

SQL> DESC LOGIN_GROUP_MENU_GRANTS;

Name Null? Type

--- -- --

LG_GROUP_KEY NOT NULL NUMBER(8)

SM_NODE_KEY NOT NULL NUMBER(8)

VISIBLE_FLAG NOT NULL VARCHAR2(1)

BROWSE_ONLY_FLAG NOT NULL VARCHAR2(1)

CREATE_USER NOT NULL VARCHAR2(15)

CREATE_DATE NOT NULL DATE

MODIFY_USER NOT NULL VARCHAR2(15)

MODIFY_DATE NOT NULL DATE

SQL> DESC USER_GROUPS;

Name Null? Type

--- -- --

USR_LOGIN NOT NULL VARCHAR2(35)

LG_GROUP_KEY NOT NULL NUMBER(8)

CREATE_USER NOT NULL VARCHAR2(15)

CREATE_DATE NOT NULL DATE

MODIFY_USER NOT NULL VARCHAR2(15)

MODIFY_DATE NOT NULL DATE

SQL> DESC LOGIN_GROUPS;

Name Null? Type

--- -- --

GROUP_KEY NOT NULL NUMBER(8)

LOGIN_GROUP NOT NULL VARCHAR2(55)

DESCRIPTION VARCHAR2(250)

USR_OWNER_LOGIN NOT NULL VARCHAR2(35)

ACTIVE_FLAG NOT NULL VARCHAR2(1)

CREATE_USER NOT NULL VARCHAR2(15)

CREATE_DATE NOT NULL DATE

MODIFY_USER NOT NULL VARCHAR2(15)

MODIFY_DATE NOT NULL DATE

SQL>

http://oracle.itags.org/q_oracle_165538.html