oracle error- 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