ORA-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.