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-09871: TASDEF_NAME: translation error while expanding ?/dbs/tasdef@.dbf.

1 Answers  


RMAN-00572: waiting for dbms_pipe input

1 Answers  


ORA-30021: Operation not allowed on undo tablespace

1 Answers  


PLS-00110: bind variable 'string' not allowed in this context

1 Answers  


TNS-00062: INTCTL: Bad command or syntax error: For help type help/h/?

1 Answers  






ORA-32809: foreign queue string is already registered

1 Answers  


RMAN-20217: datafile not part of the database

1 Answers  


NNL-00283: Next cache checkpoint occurs in string

1 Answers  


ORA-28650: Primary index on an IOT cannot be rebuilt

1 Answers  


ORA-30458: 'string.string' cannot be refreshed because the refresh mask is string

1 Answers  


ORA-39106: Worker process string failed during startup. Worker error:

1 Answers  


NMP-00007: I/O failure

1 Answers  


Categories