Home » RDBMS Server » Server Administration » Identify a tabel with a corrupt block
Identify a tabel with a corrupt block [message #282517] Thu, 22 November 2007 04:22 Go to next message
Messages: 17
Registered: November 2007
Junior Member
I have found in the alter this errors:
Corrupt block relative dba: 0x1ec48f59 (file 123, block 298841)
Bad header found during buffer read
Data in bad block -
type: 6 format: 2 rdba: 0x1ec48f68
last change scn: 0x0000.a75747f4 seq: 0x2 flg: 0x04
consistency value in tail: 0x47f40602
check value in block header: 0xfbf6, computed block checksum: 0x0
spare1: 0x0, spare2: 0x0, spare3: 0x0

How can I identify tje table with the corrupt block?
Re: Identify a table with a corrupt block [message #282526 is a reply to message #282517] Thu, 22 November 2007 04:32 Go to previous message
Michel Cadot
Messages: 65084
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
select owner, segment_name, partition_name, segment_type
from dba_extents
where file_id = 123
  and 298841 between block_id and block_id+blocks-1

Previous Topic: Exporting Data from a partitioned table
Next Topic: could not resolve service name
Goto Forum:

Current Time: Sun Jul 23 00:23:59 CDT 2017

Total time taken to generate the page: 0.06773 seconds