Corrupt blocks
From: Steve Bradshaw <sjb1970_at_googlemail.com>
Date: Thu, 7 Aug 2008 14:55:24 +0100
Message-ID: <a08b4a570808070655o638cc20eh565b58c8727c9bb8@mail.gmail.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-lReceived on Thu Aug 07 2008 - 08:55:24 CDT