OraFAQ Forum: Server Administration » Identify a tabel with a corrupt block

Home » RDBMS Server » Server Administration » Identify a tabel with a corrupt block

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Identify a tabel with a corrupt block [message #282517]

Thu, 22 November 2007 04:22

maga
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?

Report message to a moderator

Re: Identify a table with a corrupt block [message #282526 is a reply to message #282517]

Thu, 22 November 2007 04:32

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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
/

Regards
Michel

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 05:42:08 CST 2024