Convert ROWID from Leaf Block Dump

From: Michael Cunningham <napacunningham_at_gmail.com>
Date: Tue, 23 Feb 2016 08:35:39 -0800
Message-ID: <CAPt39tv3z5r45C98raQc0Z_OoxUDgggoKTt3QX8-M7qiatVUuw_at_mail.gmail.com>

Hello list, does anyone know how to convert the rowid info in a leaf block dump to a real rowid?

For example, I have this
col 1; len 6; (6): 01 00 02 f2 00 1e

The rowid for the row in the table is AAAFDFAAEAAAALyAAe.

I'm looking for the formula to do the conversion. Or at least something that gets me to this.

I'll keep looking for the solution, but I thought I'd ask.

--

Michael Cunningham

--

http://www.freelists.org/webpage/oracle-l Received on Tue Feb 23 2016 - 17:35:39 CET