Re: How to associate a rowid with a table?

The method depends on the version
of Oracle.

Under version 7, the rowid is present as

    file_number . row number in block . block number

You can query dba_extents with the file number and block number

    file_id = {your file number}
and {your block number} between block_id and block_id + blocks

Under version 8, you can use functions in the dbms_utilities package to extract the file and block numbers from the rowid.

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Jeffery Cann wrote in message <388DC816.6350B924_at_mcgraw-hill.com>...
>Hello.
>
>Given that a rowid specifies a particular physical location of a row in
>a database, if I only have a rowid, is it possible to determine which
>schema and table it resides in? I was thinking this might be stored in
>the Data Dictionary, but then again...
>
>Thanks
>Jeff
>
Received on Tue Jan 25 2000 - 13:05:29 CST