Corrupt blocks

  • From: "Steve Bradshaw" <sjb1970@xxxxxxxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 7 Aug 2008 14:55:24 +0100

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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 08-2008