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

See also

dbms_utility

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1745346479, '3.15.7.20', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/installed/packages/dbms/utility/data-block-address-conversion/index(54): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78