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 |
PCC-02019: Preprocessor warning at line number, column number, file string:
DRG-12511: use ctx_ddl.create_stoplist to create stoplists
DRG-50302: server error reading OOB break queue; cannot detect interrupts
ORA-13752: User "string" must be SYS or must have the "ADMINISTER ANY SQL TUNING SET" privilege.
DRG-13311: USER_LEXER stored procedure name contains a semicolon
PLS-00729: only widening of the collection element type is allowed
ORA-10630: Illegal syntax specified with SHRINK clause
SQL*Loader-00946: OCI error while string for table string subpartition string
ORA-06026: NETASY: port close failure
NNL-00831: Deletes refused, name is not a leaf name: number
DRG-11505: long data on line string not found or invalid
DRG-50951: Unable to resolve element name for attribute string