ORA-00057: maximum number of temporary table locks exceeded

Cause : The number of temporary tables equals or exceeds the number of temporary table locks. Temporary tables are often created by large sorts.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Increase the value of the TEMPORARY_TABLE_LOCKS initialization parameter and warm start.

update : 28-07-2017

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

  • ora-22331 : cannot alter an incomplete type
  • ora-31465 : cannot obtain a lock on the subscription
  • ora-38792 : encountered unknown flashback record from release string
  • ora-25950 : missing where clause in join index specification
  • ora-28169 : unsupported certificate type
  • ora-16038 : log string sequence# string cannot be archived
  • ora-29656 : Invalid option for USING
  • ora-02213 : duplicate PCTUSED option specification
  • ora-29275 : partial multibyte character
  • ora-02476 : can not create index due to parallel direct load on table
  • ora-02042 : too many distributed transactions
  • ora-40321 : invalid bin number, is zero or negative value
  • ora-02470 : TO_DATE, USERENV, or SYSDATE incorrectly used in hash expression.
  • ora-27486 : insufficient privileges
  • ora-07578 : szprv: $FIND_HELD failure
  • ora-10582 : The control file is not a backup control file
  • ora-36267 : (XSCGMDLAGG09) workspace object has no dimensions, so it cannot have a qualified data reference.
  • ora-31215 : DBMS_LDAP: PL/SQL - Invalid LDAP mod value.
  • ora-26024 : SKIP_UNUSABLE_INDEXES requested and index segment was initially unusable
  • ora-33012 : (XSAGDNGL05) AGGMAP workspace object contains invalid syntax.
  • ora-31051 : Requested access privileges not supported
  • ora-40282 : invalid cost matrix
  • ora-37031 : (XSMLTMAINT02) You cannot DELETE values of dimension workspace object in MULTI mode.
  • ora-29806 : specified binding does not exist
  • ora-02201 : sequence not allowed here
  • ora-30117 : syntax error at 'string' at the start of input
  • ora-07402 : sprst: cannot restore user signal handler.
  • ora-23503 : error occurred during IAS instantiation
  • ora-32631 : illegal use of objects in MODEL
  • ora-15198 : operation string is not yet available
  • Oracle Database Error Messages

    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.