How to select non-corrupted data from segment with corrupted blocks

Post date: 01-Jun-2009 12:10:25

Setting the event in a Session

------------------------------------------

 Connect to Oracle as a user with access to the corrupt table and issue the command:

                  ALTER SESSION SET EVENTS  '10231 TRACE NAME CONTEXT FOREVER, LEVEL 10';

 Now you should be able to issue a CREATE TABLE AS SELECT operation against the corrupt table to extract data from all non-corrupt  blocks, but an export would still fail as the event is only set

 within your current session.

         Eg:

                  CREATE TABLE salvage_emp

                   AS SELECT * FROM corrupt_emp;