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..

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-39305: specified schema "string" does not exist

1 Answers  


ORA-01080: error in shutting down ORACLE

1 Answers  


ORA-16201: Skip procedure requested to apply statement

1 Answers  


TNS-00084: * trace_off - ask process name to turn tracing off

1 Answers  


ORA-29854: keyword BITMAP may not be used in creating domain indexes

1 Answers  






TNS-04047: Invalid specification for destination

1 Answers  


ORA-19860: piece validation cannot be performed more than once

1 Answers  


ORA-14064: Index with Unusable partition exists on unique/primary constraint key

1 Answers  


ORA-37079: (XSMCSESS07) Aggmap workspace object cannot be used for AGGREGATE.

1 Answers  


TNS-00116: Pump failed during initial bequeath

1 Answers  


PCC-00082: Length and scale specifications must be an integer

1 Answers  


RMAN-06490: WARNING: limit of autobackups for the day has been reached

1 Answers  


Categories