How to fix the error ORA-00062: DML full-table lock cannot be acquired; DML_LOCKS is 0?

In this post, you’ll learn more about the Oracle ErrorORA-00062: DML full-table lock cannot be acquired; DML_LOCKS is 0 with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

Reason for the Error ORA-00062: DML full-table lock cannot be acquired; DML_LOCKS is 0

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

How to fix the Error ORA-00062: DML full-table lock cannot be acquired; DML_LOCKS is 0 ?

You can fix this error in Oracle by following the below steps

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