Try my app Expense Manager @ google play and amazon store.

Monday, January 28, 2013

ORA-00057 maximum number of temporary table locks exceeded


Error Code
ORA-00057

Description
maximum number of temporary table locks exceeded

Cause
Possible cause of this error is when 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.


reference

No comments:

Post a Comment

Follow by Email

Google+ Badge