Oracle Error ORA-25158: Cannot specify RELY for foreign key if the associated primary key is NORELY

Oracle Error Message

ORA-25158: Cannot specify RELY for foreign key if the associated primary key is NORELY

Reason for the Error

RELY is specified for the foreign key contraint, when the associated primary key constraint is NORELY.

Solution

Change the option of the primary key also to RELY.