Database Error Messages

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

OCI-22813

The operand value exceeds the system limits.

Cause

The object or collection value was too large. Either the size of the value might have exceeded 30 KB in a SORT context, or the size might be too big for the available memory.


Action

Avoid parallelism of objects larger than 30 KB when sorting. This can be done by using the NO_PARALLEL hint. Alternatively, parallelism can be done without SORT BY.