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

ORA-29556: object type has changed

1 Answers  


UDI-00016: 'string' parameter requires a value.

1 Answers  


ORA-00981: cannot mix table and system auditing options

1 Answers  


ORA-10618: Operation not allowed on this segment

1 Answers  


KUP-04054: internal error: invalid bad row number identified for bad column number

1 Answers  


ORA-13181: unable to determine length of column string_SDOINDEX.SDO_CODE

1 Answers  


ORA-31075: invalid string declaration in XML Schema

1 Answers  


ORA-32132: maximum iterations cannot be changed

1 Answers  


ORA-02296: cannot enable (string.string) - null values found

1 Answers  


DRG-13007: cannot define an alternate value for the DEFAULT sub lexer

1 Answers  


ORA-40251: no support vectors were found

1 Answers  


DRG-11860: Connection Establishment Interrupted

1 Answers  


Categories