Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-02087: object locked by another process in same transaction
- 1 Answers
- 2847 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 |
ORA-02799: Unable to arm signal handler
ORA-00481: LMON process terminated with error
RMAN-20201: datafile not found in the recovery catalog
ORA-19616: output filename must be specified if database not mounted
PCC-00062: Must use option SQLCHECK=SEMANTICS(FULL) when there is embedded PL/SQL
TNS-04016: Connecting to string
ORA-01554: out of transaction slots in transaction tables
ORA-01719: outer join operator (+) not allowed in operand of OR or IN
ORA-14614: List value 'string' specified twice in subpartition 'string'
TNS-12544: TNS:contexts have different wait/test functions
NNL-00245: General request processing is currently enabled
ORA-14402: updating partition key column would cause a partition change
Oracle Errors 
