Re: find file_id or block_id from data block address

From: Tanel Põder <tanel.poder.003@xxxxxxx>
To: "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
Date: Thu, 22 Dec 2005 13:09:02 -0600

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@xxxxxxxxx> To: "oracle-l" <oracle-l@xxxxxxxxxxxxx> 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

References:

find file_id or block_id from data block address
From: Prem

Re: find file_id or block_id from data block address

Other related posts: