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

ORA-09974: skxfidini: Error Initializing SDI Channel

1 Answers  


NNL-00986: Reforwarded requests expired: number

1 Answers  


ORA-06610: LU6.2 Driver: Failed during deallocation

1 Answers  


LRM-00109: could not open parameter file 'string'

1 Answers  


ORA-27208: syntax error in device PARMS - environment variable value missing

1 Answers  






PLS-00128: Illegal number of arguments for pragma string

1 Answers  


ORA-00215: must be at least one controlfile

1 Answers  


DRG-52112: improper Chinese string string of length number

1 Answers  


NZE-28778: Configuration parameter is not specified in the proper format.

1 Answers  


ORA-24301: null host specified in thread-safe logon

1 Answers  


SQL-02134: Invalid runtime context

1 Answers  


ORA-10920: Cannot offline tablespace belonging to default temporary tablespace group

1 Answers  


Categories