Welcome to plsql4all.blogspot.com SQL, MYSQL, ORACLE, TERADATA, MONGODB, MARIADB, GREENPLUM, DB2, POSTGRESQL.

Saturday 23 April 2016

ORA-00057

             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.

No comments:

Post a Comment

Please provide your feedback in the comments section above. Please don't forget to follow.