Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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



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

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-07574: szrfc: $GETUAI failure

1 Answers  


ORA-19687: SPFILE not found in backup set

1 Answers  


ORA-12722: regular expression internal error

1 Answers  


ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer

1 Answers  


ORA-02448: constraint does not exist

1 Answers  






ORA-07443: function string not found

1 Answers  


NID-00330: The following datafiles are offline immediate:

1 Answers  


ORA-16713: The resource guard timed out while servicing the request.

1 Answers  


ORA-09961: Unable to restore termination signal handler

1 Answers  


ORA-00384: Insufficient memory to grow cache

1 Answers  


ORA-27026: skgfrls: sbtend returned error

1 Answers  


RMAN-06280: Report of obsolete backups and copies

1 Answers  






Categories