ORA-00056 DDL lock on object ‘%s.%s’ 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.
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.
Cause: Ran out of DML lock state objects. Action: Increase the value of the DML_LOCKS initialization parameter and warm start.
Cause: Interested resource is busy. Action: Retry if necessary or increase timeout.
Cause: Ran out of enqueue state objects. Action: Increase the value of the ENQUEUES initialization parameter.
Cause: Ran out of enqueue resources. Action: Increase the value of the ENQUEUE_RESOURCES initialization parameter.
Cause: Usually due to a dead instance. Action: Check for any dead, unrecovered instances and recover them.
Cause: Could not obtain the operating system resources necessary to cover an oracle enqueue. This is normally the result of an operating system user quota that is too low. Action: Look up the operating system error in your system documentation and perform the needed action.
Cause: The user attempted to set timed_statistics to FALSE when statistics_level was not BASIC. timed_statistics is required to be TRUE to collect meaningful statistics when statistics_level is set to TYPICAL or ALL. Action: Either set timed_statistics to TRUE or set statistics_level to BASIC.
Cause: Execution of the inter-instance operation failed. Action: Check the status of the target instance. The operation may have partially executed. Verify the result of the intended operation.
Cause: An attempt was made to use an invalid application service. Action: Use a valid service name from SERVICE$ or add a new service using the DBMS_SERVICE package.