Oracle DBA, How To, Error, Cause and Action

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.

No comments:

Post a Comment

Thanks for your comment.