Home Privacy Policy Feedback Link to us Site Map

Oracle/PLSQL: ORA-00057 Error

Error:

 ORA-00057: maximum number of temporary table locks exceeded

Cause:

 The number of temporary tables has reached or exceeded the number of temporary table locks allowed by Oracle.

Action:

 The options to resolve this Oracle error are:
  1. This error is most commonly caused by an SQL statement that has performed a very large sort. The sort has created a number of temporary tables that has exceeded the limit specified in Oracle.

To correct this problem, increase the TEMPORARY_TABLE_LOCKS parameter in Oracle and perform a restart in Oracle.