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-30933: Element 'string' may not appear at this point within parent 'string'

1 Answers  


ORA-19649: offline-range record recid string stamp string not found in file string

1 Answers  


ORA-10921: Cannot drop tablespace belonging to default temporary tablespace group

1 Answers  


PLW-05004: identifier string is also declared in STANDARD or is a SQL builtin

1 Answers  


ORA-02459: Hashkey value must be a positive integer

1 Answers  






ORA-09936: Open of ORACLE password file for write failed.

1 Answers  


PCB-00501: Runtime context variable "string" not of correct type

1 Answers  


ORA-16137: No terminal recovery is required

1 Answers  


ORA-29278: SMTP transient error: string

1 Answers  


NZE-29045: Renegotiation request has been refused.

1 Answers  


RMAN-08544: channel string: specifying archivelog(s) for proxy restore

1 Answers  


ORA-16638: could not get the instance status

1 Answers  


Categories