How to fix the Oracle error ORA-25158: Cannot specify RELY for foreign key if the associated primary key is NORELY?

In this post, you’ll learn more about the Oracle ErrorORA-25158: Cannot specify RELY for foreign key if the associated primary key is NORELY with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

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

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

How to fix the Error ORA-25158: Cannot specify RELY for foreign key if the associated primary key is NORELY ?

You can fix this error in Oracle by following the below steps

Change the option of the primary key also to RELY.