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

IMG-00512: multiple incompatible scaling parameters found

1 Answers  


DRG-12439: highlight table read failed

1 Answers  


ORA-01910: TABLES keyword expected

1 Answers  


ORA-13032: Invalid NULL SDO_GEOMETRY object

1 Answers  


DRG-12431: configuration section string not found

1 Answers  






PCC-02204: EXEC SQL INCLUDE not permitted from within an included file

1 Answers  


ORA-12061: invalid ALTER MATERIALIZED VIEW option

1 Answers  


RMAN-07502: List of Files Unknown to the Database

1 Answers  


RMAN-06040: controlfile is already restored to file string

1 Answers  


ORA-01271: Unable to create new file name for file string

1 Answers  


ORA-10565: Another test recovery session is active

1 Answers  


DRG-10202: server failed to register

1 Answers  


Categories