DML full-table lock cannot be acquired; DML_LOCKS is 0

Solution ID:ORA-00062

Type: Oracle

Cause

The instance was started with DML_LOCKS = 0, and the statement being executed needs a full-table lock (S, X, or SSX).

Actions

Restart the instance with DML_LOCKS not equal to zero, and reexecute the statement.

Try the following links for this error:


http://docs.oracle.com/cd/E16655_01/server.121/e26079/e0.htm


https://community.oracle.com/message/3847752


https://community.oracle.com/message/9316784


https://community.oracle.com/message/9446075


https://community.oracle.com/message/2025568


https://community.oracle.com/message/4497062


https://community.oracle.com/message/1117811


https://community.oracle.com/message/1228927


Browse all solutions to database errors from Oracle, MS SQL, or MySQL