Re: Can you determine table from ROWID?

In article <CyMKxw.tC_at_trapac.com>, karl_at_trapac.com (Karl Kraft) wrote:

> I'm looking for a simple way to determine the table a record is
> in, given the ROWID of the record.

The ROWID is composed of 3 pieces.

1) the File number
2) the block number within the file
3) the row number within the block

Using the file number and block number you can look at the DBA_EXTENTS table and get the the table name for the table containing the ROWID in question

WHERE
         File_ID = (file_number)
   and (block_number) between Block_ID and Block_ID + Blocks

Good Luck,

-- 
Chip  Dawes
I only speak for myself           NOT for my employer