Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: to determine row position
Indra,
As u know the rowid consists of 3 components namely the datafile number, the block number and a running seq no within the block.
So by knowing the rowid, u come to know the exact physical address of the record.
Hope this answers your question...
Regards
Rajagopal Venkataramany
On Thu, 14 Dec 2000 16:06:15 -0800, ORACLE-L_at_fatcity.com wrote:
> Dear DBA,
>
> would I know the position of record in a table if
> I know the rowid, such as :
>
> ROWID INDICATI
> ------------------ --------
> 0006E87C.001B.0014 USA
>
> Please advise. Thank you.
>
> Indra
>
>
Regards
Rajagopal Venkataramany
![]() |
![]() |