Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


ORA-02087: object locked by another process in same transaction



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

Post New Answer

More Oracle Errors Interview Questions

SQL*Loader-00526: OCI return status: success with info

1 Answers  


TNS-12550: TNS:syntax error

1 Answers  


ORA-01560: LIKE pattern contains partial or illegal character

2 Answers  


ORA-04093: references to columns of type LONG are not allowed in triggers

1 Answers  


SQL*Loader-00257: TERMINATED BY EOF option not valid with ENCLOSED BY option

1 Answers  


ORA-02801: Operations timed out

1 Answers  


QSM-02113: expression in select list references multiple tables or views

1 Answers  


QSM-02041: nested aggregate function

1 Answers  


ORA-04082: NEW or OLD references not allowed in table level triggers

2 Answers   Satyam,


ORA-30574: Cannot create rollback segment in tablespace with AUTO segment space management

2 Answers  


ORA-19698: %s is from different database: id=string, db_name=string

1 Answers  


PCC-00104: FOR clause is an Oracle extension

1 Answers  


Categories