Re: Help with corrupt block

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Fri, 22 Nov 2002 00:13:17 +1000
Message-ID: <XM4D9.81266$g9.228969@newsfeeds.bigpond.com>

"Alistair Thomson" <thomson_alistair_at_no.spam.yahoo.co.uk> wrote in message news:arg48q$nv4$1$8300dec7_at_news.demon.co.uk...
> Hi
>
> The datafile is fine and the corruption seems to be a memory block rather
> than a physical block in the datafile. Every time the delete is run the
> block that has a corruption in it changes! I can insert and select from
the
> table just can't do a large delete - well, if you call 30,000 rows large!
>
> What's plan B?????
>
> Alistair

Hi Alistair,

OK, Plan B (version 1).

If recovering with a backup file has zip effect, but you can successful read from the so-called stuffed blocks, I would consider recreating the table by moving the bugger. There appears to be issues with the header portion of the block which doesn't have to be changed during a select or impacted by inserts into different blocks hence why those operations are hunky dory.

Issue the 'alter table stuffed_bowie move tablespace wherever, rebuild your indexes and see if the regenerated table is now clean.

If not, then Plan B (version 2a ;)

Cheers

Richard Received on Thu Nov 21 2002 - 08:13:17 CST