Database Error Messages

OCI-42710

Cannot enable logical replication for JSON-relational duality view 'string' because the identifying (primary or unique) key column(s) or _id field for the table 'string' were not selected in the view

Cause

Logical replication cannot be enabled for the specified duality view because an identifying key was not selected for at least one table included in the view. Every table in the duality view must select a primary or unique key, or have an '_id' field that refers to any column.


Action

Ensure that the JSON-relational duality view selects primary or unique key on all tables or define the JSON field '_id' for each instance of a table without an identifying primary or unique key.