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

DRG-12404: more than one template string found

1 Answers  


ORA-25109: standby lock name space has illegal character 'string'

1 Answers  


TNS-04001: %s

1 Answers  


ORA-23603: STREAMS enqueue aborted due to low SGA

1 Answers  


ORA-29284: file read error

1 Answers  






ORA-21609: memory being resized without being allocated first

1 Answers  


PLS-00733: RPCs to variable argument functions are not allowed

1 Answers  


DRG-12436: document table allocation failed

1 Answers  


ORA-19705: tag value exceeds maximum length of string characters

1 Answers  


ORA-02152: Invalid ALTER TABLESPACE ... RENAME option

1 Answers  


ORA-19685: SPFILE could not be verified

1 Answers  


TNS-00246: Connection Manager: Failed to start tracing

1 Answers  


Categories