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 |
ORA-00164: distributed autonomous transaction disallowed within migratable distributed transaction
KUP-04075: no read access to directory object string
IMG-00561: input format does not support channel selection
ORA-22828: input pattern or replacement parameters exceed 32K size limit
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.
PCB-00633: Invalid host variable and attribute pairing
ORA-02842: Client unable to fork a server
ORA-30365: left relation in the JOIN KEY clause cannot be same as right
ORA-38765: Flashed back database cannot be opened read-only.
TNS-02509: Authentication: invalid process state
ORA-37003: (AWLISTALL01) number readers
ORA-31478: could not detach LogMiner session after change set advance