ORA-02087: object locked by another process in same transaction



ORA-02087: object locked by another process in same transaction..

Answer / guest

Cause: A database link is being used in the cluster database
environment that loops back to the same instance. One
session is trying to convert a lock that was obtained by the
other session.

Action: Get the more restrictive lock first. For example, if
session 1 gets a share lock and session 2 gets an exclusive
lock on the same object, get the exclusive lock first. Or,
simply use the same session to access the object.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-24076: cannot perform operation string for NON_PERSISTENT queue string.string

1 Answers  


RMAN-20032: checkpoint change# too low

1 Answers  


NNL-00995: Unmatched responses received: number

1 Answers  


KUP-03006: error initializing handle for character set string

1 Answers  


QSM-01085: materialized view, string, has a lossy join between tables, string

1 Answers  


TNS-12509: TNS:listener failed to redirect client to service handler

1 Answers  


ORA-06516: PL/SQL: the Probe packages do not exist or are invalid

1 Answers  


ORA-14189: this physical attribute may not be specified for an index subpartition

1 Answers  


ORA-02789: Maximum number of files reached

1 Answers  


ORA-00163: internal database name length string is greater than maximum (string)

1 Answers  


ORA-15196: invalid ASM block header [string:string] [string] [string] [string] [string != string]

1 Answers  


NNL-01006: META VIOLATION responses received: number

1 Answers  


Categories