ORA-00057: maximum number of temporary table locks exceeded
- 1 Answers
- 2956 Views
- I also Faced
- E-Mail Answers
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 |
ORA-29915: cannot select FOR UPDATE from collection operand
ORA-13362: disjoint sub-element in a compound polygon
PLS-00636: overriding method requires OVERRIDING keyword
PLS-00318: type "string" is malformed because it is a non-REF mutually recursive type
ORA-38444: statistics do not exist for the expression set
DRG-11224: Third-party filter is unable to create or write to temporary file.
NNL-01005: UNKNOWN TYPE responses received: number
ORA-14162: subpartition "string": sum of PCTUSED and PCTFREE may not exceed 100
RMAN-06066: the target database must be mounted when issuing a RECOVER command
DRG-11604: URL store: access to string is denied
ORA-32840: property name cannot be NULL
IMG-00545: invalid cut values specified
Oracle Errors 
