ORA-00057 maximum number of temporary table locks exceeded
Cause ORA-00057: 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 "temporary_table_locks" init.ora parameter and warm start.
Explanation: In Oracle 8 this was 'Out of DDL locks' so the init.ora parameter for DDL locks should be increased.
For Oracle 7 this implies either out of shared pool space or out of temporary table locks. Diagnosis: - Increase shared_pool_size AND temporary_table_locks and restart the instance.
|