Database Error Messages

OCI-40897

Cannot create JSON Relational Duality View 'view_name': The primary key or unique key column 'column_name' cannot be marked with the UPDATE annotation.
  • view_name: The duality view name used in the create statement.
  • column_name: The primary or unique key column name annotated with the WITH UPDATE annotation.

Cause

An attempt was made to create a duality view with an updatable primary key or unique key column, which is not allowed.


Action

Remove the WITH UPDATE annotation for all of the primary key or unique key columns, and retry the operation.