Oracle Error ORA-00057: maximum number of temporary table locks exceeded

Oracle Error Message

ORA-00057: maximum number of temporary table locks exceeded

Reason for the Error

The maximum number of temporary table locks permitted by Oracle has been reached or exceeded by the number of temporary tables.

Solution

The most common cause of this error is a SQL statement that performed a very large sort.

The sort created more temporary tables than the limit set by Oracle.

To resolve this issue, increase the TEMPORARY TABLE LOCKS parameter in Oracle and restart the database.