Cause
The number of temporary tables equals or exceeds the number of temporary table locks. Temporary tables are often created by large sorts.
The number of temporary tables equals or exceeds the number of temporary table locks. Temporary tables are often created by large sorts.
Increase the value of the TEMPORARY_TABLE_LOCKS initialization parameter and warm start.
Try the following links for this error:
http://docs.oracle.com/cd/E16655_01/server.121/e26079/e0.htm
http://docs.oracle.com/cd/E16655_01/timesten.121/e21636/awt_trouble.htm
https://community.oracle.com/message/10573879
https://community.oracle.com/message/9316784
https://community.oracle.com/message/9446075
https://community.oracle.com/message/2025568
https://community.oracle.com/message/4497062
https://community.oracle.com/message/1117811
https://community.oracle.com/message/1228927
Browse all solutions to database errors from Oracle, MS SQL, or MySQL