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 |
SQL*Loader-00526: OCI return status: success with info
TNS-12550: TNS:syntax error
ORA-01560: LIKE pattern contains partial or illegal character
ORA-04093: references to columns of type LONG are not allowed in triggers
SQL*Loader-00257: TERMINATED BY EOF option not valid with ENCLOSED BY option
ORA-02801: Operations timed out
QSM-02113: expression in select list references multiple tables or views
QSM-02041: nested aggregate function
ORA-04082: NEW or OLD references not allowed in table level triggers
ORA-30574: Cannot create rollback segment in tablespace with AUTO segment space management
ORA-19698: %s is from different database: id=string, db_name=string
PCC-00104: FOR clause is an Oracle extension