find file_id or block_id from data block address 2005-12-22 - By Tanel Poder
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" <premjhere@(protected)>
To: "oracle-l" <oracle-l@(protected)>
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
|
|
