Re: Mapping tablerow to datablock?

From: Douglas Hawthorne <douglashawthorne_at_yahoo.com.au>
Date: Wed, 24 Mar 2004 11:54:50 GMT
Message-ID: <eGe8c.122621$Wa.9486@news-server.bigpond.net.au>

"grz02" <grz01_at_spray.se> wrote in message news:1641ee43.0403240334.7f43dbd2_at_posting.google.com...
> Hi,
> Given a table-row in Oracle, is there any way to see in which
> datablock it is stored?
> Does the ROWID purvey this info, or any other way?
> Thanks,

Hi,

You might want to check out the DBMS_ROWID package, especially the ROWID_BLOCK_NUMBER function in the "Supplied PL/SQL Packages and Types" manual.

Daniel Morgan has some examples at
http://www.psoug.org/reference/dbms_rowid.html that you may wish to explore.

Douglas Hawthorne Received on Wed Mar 24 2004 - 05:54:50 CST