Monday, 11 June 2012

ORA-00057: maximum number of temporary table locks exceeded

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