Database Error Messages

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

ORA-30418

cannot lock rows in external partitions of a hybrid partitioned table with SELECT FOR UPDATE

Cause

An attempt was made to lock rows in one or multiple external partitions of a hybrid partitioned table using SELECT FOR UPDATE. Rows in external partitions cannot be locked.


Action

Do not use SELECT FOR UPDATE for external partitions of a hybrid partitioned table. Restrict the SELECT FOR UPDATE to reference only internal partitions of a hybrid partitioned table.