Database Error Messages

Release
toggle
  • 23ai
Updated
Jun 24, 2024

ORA-42646

Cannot create JSON-relational duality view 'view_name'. The primary key 'column_name' cannot be marked with the HIDDEN annotation.
  • view_name: The duality view name used in the create statement.
  • column_name: The primary or unique key column name annotated with the HIDDEN annotation.

Cause

An attempt is being made to create a duality view with a hidden primary key, which is not allowed.


Action

Remove the HIDDEN annotation for all of the primary keys and retry the operation.