Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-02087: object locked by another process in same transaction
- 1 Answers
- 2782 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 |
TNS-00293: Trace File Name : string
ORA-14045: only one partition may be modified
ORA-07286: sksagdi: cannot obtain device information.
RMAN-08018: channel string: starting archive log restore to user-specified destination
ORA-27005: cannot open file for async I/O on device not supporting async
ORA-08186: invalid timestamp specified
ORA-16013: log string sequence# string does not need archiving
RMAN-08107: channel string: block restore complete
ORA-16187: LOG_ARCHIVE_CONFIG contains duplicate, conflicting or invalid attributes
ORA-02451: duplicate HASHKEYS specification
ORA-00827: could not shrink sga_target to specified value
ORA-01338: Other process is attached to LogMiner session
Oracle Errors 
