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-31047: Could not retrieve resource data at path string
ORA-14459: missing GLOBAL keyword
ORA-07201: slhom: oracle_home variable not set in environment.
ORA-06921: CMX: getdatmsg illegal datatype
ORA-24075: cannot specify agent with NULL address and non-NULL protocol
EXP-00095: Flashback_time and Flashback_scn are not compatible
DRG-52112: improper Chinese string string of length number
ORA-32003: error occured processing parameter 'string'
ORA-24172: rule set string.string has errors
ORA-28239: no key provided
PCC-02310: formal parameter VARCHARs should be declared as pointers
ORA-38460: filtering based on datatype "string" not supported for XML Tags