Oracle Error :: 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.