Re: corrupted block

From: K Gopalakrishnan <kaygopal_at_yahoo.com>
Date: Mon, 24 Feb 2003 09:49:00 -0800
Message-ID: <F001.00556FA1.20030224094900@fatcity.com>

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). Received on Mon Feb 24 2003 - 11:49:00 CST