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-00164: distributed autonomous transaction disallowed within migratable distributed transaction

1 Answers  


KUP-04075: no read access to directory object string

1 Answers  


IMG-00561: input format does not support channel selection

1 Answers  


ORA-22828: input pattern or replacement parameters exceed 32K size limit

1 Answers  


ORA-36774: (XSPGERRTEMPUSER) Ran out of temporary storage while writing to analytic workspace string. Free some temporary storage immediately. You can do so, for example, by DETACHING an analytic workspace.

1 Answers  






PCB-00633: Invalid host variable and attribute pairing

1 Answers  


ORA-02842: Client unable to fork a server

1 Answers  


ORA-30365: left relation in the JOIN KEY clause cannot be same as right

1 Answers  


ORA-38765: Flashed back database cannot be opened read-only.

1 Answers  


TNS-02509: Authentication: invalid process state

1 Answers  


ORA-37003: (AWLISTALL01) number readers

1 Answers  


ORA-31478: could not detach LogMiner session after change set advance

1 Answers  


Categories