Re: Oracle data block corruption error in ebs database

Posted by ErmanArslansOracleBlog on Sep 11, 2021; 10:36am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Oracle-data-block-corruption-error-in-ebs-database-tp10238p10243.html

Find the object that is sitting on block 110463 of file 352 and then we will check what we can do about it..

execute the following query :

SELECT tablespace_name, segment_type, owner, segment_name
FROM dba_extents
WHERE file_id = <file#>
and <block#> between block_id AND block_id + blocks - 1;

file# should be 352
block# should be 110463 , so the necessary replacement in the above sql and execute it.. What is the result?