Database Error Messages

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

ORA-14670

there is no usable index on the reference partitioning parent key

Cause

An attempt was made to run an operation on a reference partitioned table that requires a usable index on the reference partitioning parent key, but no such index exists.


Action

Create a usable index on the reference partitioning parent key, or rebuild the existing unusable index on the reference partitioning parent key.