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.
