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

ORA-01757: Must specify an object number

1 Answers  


TNS-00509: Buffer overflow

1 Answers  


RMAN-08506: input filename=string

1 Answers  


ORA-02494: invalid or missing maximum file size in MAXSIZE clause

1 Answers  


ORA-02077: selects of long columns must be from co-located tables

1 Answers  






ORA-32614: illegal MODEL SELECT expression

1 Answers  


ORA-36968: (XSRELTBL11) workspace object must be a relation.

1 Answers  


ORA-36704: (XSRELTBL06) workspace object should be dimensioned by workspace object.

1 Answers  


ORA-01650: unable to extend rollback segment string by string in tablespace string

1 Answers  


ORA-24098: invalid value string for string

1 Answers  


ORA-24146: rule string.string already exists

1 Answers  


ORA-30748: column string already enabled to store objects of type string.string

1 Answers  


Categories