Database Error Messages

Release
toggle
  • 23ai
  • 21c
Updated
Jun 24, 2024

ORA-14342

JavaScript Object Notation (JSON) type column can only be used to partition a table with JSON_VALUE operator

Cause

An attempt was made to create a partitioned table using a virtual column as a partitioning key column that references a JavaScript Object Notation (JSON) type column but does not contain a JSON_VALUE operator.


Action

Ensure that the virtual column used as a partition key column contains a JSON_VALUE operator if it references a JSON type column.