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-24076: cannot perform operation string for NON_PERSISTENT queue string.string
RMAN-20032: checkpoint change# too low
NNL-00995: Unmatched responses received: number
KUP-03006: error initializing handle for character set string
QSM-01085: materialized view, string, has a lossy join between tables, string
TNS-12509: TNS:listener failed to redirect client to service handler
ORA-06516: PL/SQL: the Probe packages do not exist or are invalid
ORA-14189: this physical attribute may not be specified for an index subpartition
ORA-02789: Maximum number of files reached
ORA-00163: internal database name length string is greater than maximum (string)
ORA-15196: invalid ASM block header [string:string] [string] [string] [string] [string != string]
NNL-01006: META VIOLATION responses received: number