Re: Deadlock & DBMS_ROWID weirdness.
From: Norman Dunbar <oracle_at_dunbar-it.co.uk>
Date: Thu, 3 Jan 2019 13:31:18 +0000
Message-ID: <811fd7f3-4365-e97b-f87e-c4f6693b9b2f_at_dunbar-it.co.uk>
Date: Thu, 3 Jan 2019 13:31:18 +0000
Message-ID: <811fd7f3-4365-e97b-f87e-c4f6693b9b2f_at_dunbar-it.co.uk>
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 -- http://www.freelists.org/webpage/oracle-lReceived on Thu Jan 03 2019 - 14:31:18 CET