ORA-26040: Data block was loaded using the NOLOGGING option
et pour trouver l’objet du bloc corrompu :
SELECT segment_type, segment_nameFROM dba_extentsWHERE file_id = <numero du datafile>AND block_id < <numero du bloc>AND block_id + blocks >= <numero du bloc>;
Your email address will not be published. Required fields are marked *
Save my name, email, and website in this browser for the next time I comment.
Δ
Please enable JavaScript in your browser to view the content
et pour trouver l’objet du bloc corrompu :
SELECT segment_type, segment_name
FROM dba_extents
WHERE file_id = <numero du datafile>
AND block_id < <numero du bloc>
AND block_id + blocks >= <numero du bloc>;
Josselin Joly