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.
Oracle 26ai
ORA-00057
Error Message
maximum number of temporary table locks exceeded