Welcome to plsql4all.blogspot.com SQL, MYSQL, ORACLE, TERADATA, MONGODB, MARIADB, GREENPLUM, DB2, POSTGRESQL.

Saturday 23 April 2016

ORA-00056

            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

Please provide your feedback in the comments section above. Please don't forget to follow.