Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-02087: object locked by another process in same transaction
- 1 Answers
- 2785 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 |
LSX-00165: content type of "~S" must be simple type
ORA-32800: internal error string
LPX-00605: Invalid attribute '~1S' in element '~2S'.
TNS-12166: TNS:Client can not connect to HO agent.
DRG-11445: rowid value is invalid: string
RMAN-06420: some files could not be proxy restored - aborting restore
ORA-06118: NETTCP: unable to complete handshake with ORASRV
ORA-02174: Missing required thread number
ORA-16512: parameter exceeded maximum size limit
ORA-19951: cannot modify control file until DBNEWID is completed
ORA-13119: invalid edge_id [string]
ORA-19571: %s recid string stamp string not found in controlfile
Oracle Errors 
