Oracle / PLSQL: ORA-00057 Error Message

Learn the cause and how to resolve the ORA-00057 error message in Oracle.

Description

When you encounter an ORA-00057 error, the following error message will appear:

• 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.

Resolution

The option(s) to resolve this Oracle error are:

Option #1

This error is most commonly caused by a 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.