Re: Deadlock & DBMS_ROWID weirdness.
- From: Norman Dunbar <oracle@xxxxxxxxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 3 Jan 2019 13:31:18 +0000
On 03/01/2019 10:34, Ghassan Salem wrote:
Norman,
Check the data_object_id of the table.
Yes, thanks for that. I mentioned that while the OBJECT_ID in the
deadlock header was the correct one for the table in question, the
OBJECT_ID returned by DBMS_ROWID was incorrect and referred to a
non-existent object.
The correct OBJECT_ID is 1008338 while DBMS_ROWID returns 1075419.
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
27a Lidget Hill
Pudsey
West Yorkshire
United Kingdom
LS28 7LG
Company Number: 05132767
--
//www.freelists.org/webpage/oracle-l
Other related posts: