Re: corrupted block

This might work, we can afford to forget the data. We are in the process of purging old data and this row already meets the criteria for purge.

Thanks to everyone for your input! Haven't tried anything yet as I had to drop this issue to work on a more urgent matter (if you can imagine that). Soon as the corruption problem is solved I'll report what was done.

Suzy

K Gopalakrishnan wrote:
>
> Hi,
>
> If you can afford to forget the data in the corrupted block you can use
> the event 10231 to skip the corrupted block during table scan. Set the
> event and you can do a CTAS with a new table name and then you can
> rename that as original table after dropping the original table.
>
> Here is the syntax:
>
> alter session set events '10231 trace name context forever, level 10'
>
> If you want to see the contents of that skipped blocks, you can use the
> event 10232 which dumps the contents of that blocks to the trace files.
> And if you are comfortable in reading block dumps, you can write a
> simple INSERT statement to put those rows in to the new table.
>
> KG
>
> =====
> Have a nice day !!
> ------------------------------------------------------------
> Best Regards,
> K Gopalakrishnan,
> Bangalore, INDIA.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: K Gopalakrishnan
> INET: kaygopal_at_yahoo.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Suzy Vordos
  INET: lvordos_at_qwest.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).