ORA-00057: maximum number of temporary table locks exceeded



ORA-00057: maximum number of temporary table locks exceeded..

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

PLS-00379: CASE statements are not included in this release of PL/SQL

1 Answers  


ORA-33425: (EIFMAKEF15) CAUTION: Exporting NTEXT objects using string for the EIF file character set can cause loss of data. To preserve all NTEXT data, export using the UTF8 character set for the EIF file.

1 Answers  


TNS-01076: Opened trace file: string

1 Answers  


PLS-00718: type of attribute 'string' does not allow modifications to the attribute

1 Answers  


AMD-00151: Creation of Custom Measure "string" in Workspace "string" failed

1 Answers  






QSM-02170: tables must be identical across the UNION operator

1 Answers  


TNS-02509: Authentication: invalid process state

1 Answers  


TNS-12611: TNS:operation is not portable

1 Answers  


ORA-16166: LGWR network server failed to send remote message

1 Answers  


ORA-36652: (XSDUNION11) workspace object is not a string type dimension.

1 Answers  


ORA-36712: (XSMXALLOC02) Relation workspace object must be a one-dimensional self-relation to be used as a SOURCE or BASIS with ALLOCATE.

1 Answers  


ORA-19682: file string not in block media recovery context

1 Answers  


Categories