select to_char(sys.dbms_utility.make_data_block_address(3, 2), 'XXXXXXXX') dba from dual; -- -- C00002
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