Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-02087: object locked by another process in same transaction
- 1 Answers
- 2702 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-30563: outer join operator (+) not allowed in select-list
UDI-00012: table mode imports only allow objects from one schema
RMAN-04007: WARNING from recovery catalog database: string
ORA-28576: lost RPC connection to external procedure agent
ORA-02194: event specification syntax error string (minor error string) near 'string'
QSM-01022: a more optimal materialized view than string was used to rewrite
IMG-00809: usage of IMGSimilar is incorrect
QSM-00517: Summary Advisor requires a COMPATIBLE setting of 8.1.0.0 or greater
ORA-12010: cannot create materialized view log on table owned by SYS
PCC-00064: All uses of a given host variable must use identical indicator variables.
ORA-09260: sigpidu: error obtaining process id
ORA-00037: cannot switch to a session belonging to a different server group
Oracle Errors 
