Re: How to associate a rowid with a table?

From: James Lorenzen <james_lorenzen_at_allianzlife.com>
Date: Tue, 25 Jan 2000 19:29:19 GMT
Message-ID: <86kti8$r0g$1@nnrp1.deja.com>

Yep.
In Oracle 7, the rowid breaks down to bbbbbbbb.ssss.ffff, where bbbbbbbb id the blockid and the ffff is the file id, dba_extents will show you the way.

In Oracle 8, the rowid is bigger, it contains the above, plus an object id, that can be used to get the object from dba_objects.

HTH
James

In article <388DC816.6350B924_at_mcgraw-hill.com>, Jeffery Cann <Jeffery_Cann_at_mcgraw-hill.com> wrote:
> 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
>

--
Life is complex; it has real and imaginary parts.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Jan 25 2000 - 13:29:19 CST