oracle error- ORA-00057: maximum number of temporary table locks exceeded

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:     Increase the value of the TEMPORARY_TABLE_LOCKS initialization parameter 

and warm start.

oracle error- ORA-00056: DDL lock on object 'string.string' is already held in an incompatible mode

ORA-00056: DDL lock on object 'string.string' is already held in an incompatible mode

Cause:     An attempt was made to acquire a DDL lock that is already locked.

Action:     This happens if you attempt to drop a table that has parse locks on it.

oracle error- ORA-00054: resource busy and acquire with NOWAIT specified

ORA-00054: resource busy and acquire with  NOWAIT specified

Cause:     Resource interested is busy.

Action:     Retry if necessary.