Search notes:

DBMS_UTILITY: Conversion between data block address (DBA) and file/block number

Convert a data block's file and block number to a data block address (DBA):

select
   to_char(sys.dbms_utility.make_data_block_address(3, 2), 'XXXXXXXX') dba
from
   dual;
--
--    C00002

Get the file and block number of a data block from its address:

select
   sys.dbms_utility.data_block_address_file (to_number('C00002', 'XXXXXX')) file_no,
   sys.dbms_utility.data_block_address_block(to_number('C00002', 'XXXXXX')) block_no
from
   dual;
-- 
--    FILE_NO   BLOCK_NO
-- ---------- ----------
--          3          2

DBMS_UTILITY: Conversion between data block address (DBA) and file/block number

See also