Re: find file_id or block_id from data block address

Hi,

In newer versions, there are two functions under dbms_utility.data_block_address_block and data_block_address_file. dbms_utility.make_data_block_address works the other way too.

If 7.3.4 doesn't have those functions, you could just use a newer db version for doing the calculations.

Tanel.

• Original Message ----- From: "Prem" To: "oracle-l" Sent: Thursday, December 22, 2005 10:06 AM Subject: find file_id or block_id from data block address

> Friends,
>
> How do i find the find file_id or block_id from data block address in
> v7.3.4 ?
> i.e., I have the data block address. I want to know the the find
> file_id or block_id .
>
> Can someone help me on this ?
>
> Regards,
> Prem J
> --
> http://www.freelists.org/webpage/oracle-l
>
>

--
http://www.freelists.org/webpage/oracle-l