Database Error Messages

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

ORA-00057

maximum number of temporary table locks exceeded

Cause

The number of temporary tables equals or exceeds the number of temporary table locks. Temporary tables are often created by large sorts.


Action

Increase the value of the TEMPORARY_TABLE_LOCKS initialization parameter and warm start.