RE: Corrupt blocks
Date: Thu, 7 Aug 2008 10:22:54 -0400
The message lists the block. Try dumping it to see if the block is unused. The corruption could be in an "unused" portion of the block.
If the block in question is not empty then as you can read all the data I suggest recreating the object and its dependencies. In fact I would, if possible, try an alter table move with alter index rebuilds just to be safe.
- Mark D Powell --
Phone (313) 592-5148
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Steve Bradshaw
Sent: Thursday, August 07, 2008 9:55 AM To: oracle-l_at_freelists.org Subject: Corrupt blocks Hi, We've got a table that the alert log is reporting as having acorrupt block:
Corrupt Block Found TSN = 20, TSNAME = DEVELOPMENT RFN = 10, BLK = 28391, RDBA = 41971431 OBJN = 54369, OBJD = 54369, OBJECT = SKRSAIN, SUBOBJECT = SEGMENT OWNER = SATURN, SEGMENT TYPE = Table Segment I can create a copy of this table using "create table as..." andit doesn't issue an error. So does this mean that the corruption is an unused datablock and if so will the data in the copy of the table be intact?
Thanks in advance.
SteveReceived on Thu Aug 07 2008 - 09:22:54 CDT