Corrupt blocks

From: Steve Bradshaw <sjb1970_at_googlemail.com>
Date: Thu, 7 Aug 2008 14:55:24 +0100
Message-ID: <a08b4a570808070655o638cc20eh565b58c8727c9bb8@mail.gmail.com>


Hi,

We've got a table that the alert log is reporting as having a corrupt 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..." and it 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.

Steve

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Aug 07 2008 - 08:55:24 CDT

Original text of this message