RE: Convert ROWID from Leaf Block Dump

From: Jonathan Lewis <>
Date: Tue, 23 Feb 2016 16:51:54 +0000
Message-ID: <CE70217733273F49A8A162EE074F64D9282C4706_at_EXMBX01.thus.corp>

Look at package dbms_rowid.
  1 select

  2     dbms_rowid.rowid_object('AAAFDFAAEAAAALyAAe') data_object_id ,
  3     dbms_rowid.rowid_relative_fno('AAAFDFAAEAAAALyAAe') ts_relative_file,
  4     dbms_rowid.rowid_block_number('AAAFDFAAEAAAALyAAe') block_number,
  5     dbms_rowid.rowid_row_number('AAAFDFAAEAAAALyAAe') row_in_block
  6* from dual
-------------- ---------------- ------------ ------------
         20677                4          754           30

The file and block number procedures have a second parameter to tell them whether the object is in a smallfile or bigfile tablespace (default small); there's also an "absolute" file number procedure but you have to know the schema and object name - which you can derive from the data_object_id.

Jonathan Lewis

From: [] on behalf of Michael Cunningham [] Sent: 23 February 2016 16:35
To: oracle-l_at_freelists org
Subject: Convert ROWID from Leaf Block Dump

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

-- Received on Tue Feb 23 2016 - 17:51:54 CET

Original text of this message