javAbout.com » Oracle Error Codes – ORA-00062 – DML full-table lock cannot be acquired; DML

All About For Java

Oracle Error Codes – ORA-00062 – DML full-table lock cannot be acquired; DML_LOCKS is 0

13 July 2009 140 views No Comment

ERROR

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

CAUSE

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

ACTION

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

Tags: another instance has a different DML_LOCKS setting, cannot be acquired, db, DML full, DML full-table lock, DML full-table lock cannot be acquired; DML_LOCKS is 0, DML_LOCKS is 0, error, error code list, error codes, java database, ORA-00000, ORA-00062, oracle, oracle db error, oracle db error codes, ORACLE ERROR CODE