Database Error Messages

ORA-63104

Cannot create JSON-relational duality view 'string': foreign key column 'string' of table 'string' should be part of the primary or unique key of the same table

Cause

The foreign key column can only be selected if it is also part of a primary or unique key of the same table, which is required to uniquely identify rows in the duality view objects.


Action

Add the foreign key columns to the primary or unique key of the same table, or remove it from the SELECT statement.