Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-32002: cannot create SPFILE already being used by the instance

1 Answers  


ORA-32144: Cannot perform operation on a null interval

1 Answers  


TNS-12213: TNS:incomplete PREFERRED_CMANAGERS binding in TNSNAV.ORA

1 Answers  


ORA-27021: sequential file handle must be specified

1 Answers  


RMAN-06003: ORACLE error from target database: string

1 Answers  






ORA-16576: failed to update Data Guard configuration file

1 Answers  


ORA-31094: incompatible SQL type "string" for attribute or element "string"

1 Answers  


ORA-38723: Invalid SCN expression.

1 Answers  


RMAN-06557: unable to restore archived log thread number, sequence number

1 Answers  


NID-00321: Proceeding with operation

1 Answers  


SQL*Loader-00910: Error binding input variables for upi: [number]

1 Answers  


ORA-17505: ksfdrsz:string Failed to resize file to size string blocks

1 Answers  






Categories