ORA-24775: cannot prepare or commit transaction with
non-zero lock value



ORA-24775: cannot prepare or commit transaction with non-zero lock value..

Answer / guest

Cause: An attempt was made to detach the transaction with a
non-zero lock value.

Action: Detach the transaction with lock value set to zero
and then try to prepare or commit the transaction.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NZE-29026: Decryption failure

1 Answers  


ORA-13420: the SRID of the geometry parameter was not null

1 Answers  


ORA-09857: smprset: vm_protect error while protecting pga.

1 Answers  


ORA-39305: specified schema "string" does not exist

1 Answers  


RMAN-10015: error compiling PL/SQL program

1 Answers  






ORA-09931: Unable to open ORACLE password file for reading

1 Answers  


ORA-03289: partition name and segment type do not match

1 Answers  


ORA-25186: INCLUDING clause specified for index-organized table without OVERFLOW

1 Answers  


ORA-23364: Feature not enabled: Advanced replication

1 Answers  


ORA-32107: internal OCI memory allocation failure

1 Answers  


ORA-27056: could not delete file

1 Answers  


RMAN-04027: unable to write to a temporary file: "string"

1 Answers  


Categories