How to solve Oracle Database Error 57 (ora-00057)

Oracle Error Code
   ora-00057

Description
   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.
How to Solve
   Increase the value of the TEMPORARY_TABLE_LOCKS initialization parameter and warm start.

Do you have question or do you know about solution ?

Share with us. (No registration required)
  
Your Name
Question, comment or solution
Similar Errors
  ORA-00001    ORA-00017    ORA-00018    ORA-00057    ORA-00058    ORA-00059    ORA-00060  Others

Main Page      Contact Us      Tools & Softwares      Server Monitoring Softwares