ORA-02087: object locked by another process in same transaction
- 1 Answers
- 2342 Views
- I also Faced
- E-Mail Answers
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 |
RMAN-08024: channel string: restore complete
ORA-32603: invalid FREEPOOLS LOB storage option value
ORA-09283: sllfsk: error skipping records
DRG-11726: phrase is not a preferred term
ORA-24321: inconsistent parameters passed
ORA-13528: name (string) is already used by an existing baseline
TNS-04083: Failed to save password
ORA-06908: CMX: error during transfer of ORACLE_SID
ORA-07497: sdpri: cannot create trace file 'string'; errno = string.
ORA-30687: session terminated by debugger
ORA-28011: the account will expire soon; change your password now
ORA-37071: You may not execute a parallel OLAP operation against updated but uncommitted AW string.
Oracle Errors 
