ORA-02087: object locked by another process in same transaction
- 1 Answers
- 2041 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 |
SQL-02132: Unable to allocate runtime context sdfla asdjklfajs jfja ajsdf
PLS-01425: Connect-by clause
ORA-12923: tablespace string is in force logging mode
ORA-07277: spdde: illegal pid passed as argument.
KUP-04016: unknown SLF status code number
ORA-24364: internal error while padding blanks
NZE-28866: Invalid peer certificate encoding
TNS-04141: Unable to find CMAN.ORA file.
QSM-01061: illegal query expression
ORA-38757: Database must be mounted EXCLUSIVE and not open to FLASHBACK.
ORA-24344: success with compilation error
RMAN-06132: cannot backup datafile string because it is not in the controlfile
Oracle Errors 
