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-31409: one or more values for input parameters are incorrect

1 Answers  


ORA-22314: method information mismatch in ALTER TYPE

1 Answers  


ORA-16192: Primary and standby network integrity mismatch

1 Answers  


SQL*Loader-00431: illegal NULLIF or DEFAULTIF clause specified for nested table column string

1 Answers  


IMG-00558: incorrect number of contrast values

1 Answers  






ORA-02021: DDL operations are not allowed on a remote database

1 Answers  


ORA-30029: no active undo tablespace assigned to instance

1 Answers  


ORA-28603: statement not permitted on empty tables

1 Answers  


ORA-00278: log file 'string' no longer needed for this recovery

1 Answers  


ORA-22995: TABLESPACE DEFAULT option is invalid in this context

1 Answers  


DRG-50804: failed to exec cursor

1 Answers  


UDE-00013: internal expdp error.

1 Answers  


Categories