ORA-1578 Corrupt database block in Oracle 7
Date: 4 Jan 1995 16:19:29 GMT
Message-ID: <3eehqh$lsq_at_news.kth.se>
I have an Oracle 7 on an Windows NT 3.1 server. My largest table has a million rows and is in a 300MB datafile. One block is corrupt and I wish to read the rest of the data to save it in an other table.
Oracle Support has suggested me to set certain events in the init.ora file to skip corrupt blocks and then do a select (full table scan) to retrieve all rows. The event is supposed to skip the corrupt block and continue fetching rows through the whole table.
I've done this before on a Oracle ver 6 database on a unix machine with no problems.
On this occasion it does not work. I still get ORA-1578 and the search stops. A testcase on oracle7 on unix doesn't work either.
Questions:
- Has anyone tried this successfully on oracle7 ?
- Is there a way of getting the remaining rows without guessing the row-id of half a million rows?
Please mail any suggestions to wo(a)dialog.se
MANY THANKS
- Wilhelm Olander [wo_at_dialog.se]
-- --------- Per Rasmussen Snail: Larsbergsv. 28 2tr ned E-mail: d89-pra_at_nada.kth.se S-181 39 Lidingo Tel +46 8 765 97 35 SwedenReceived on Wed Jan 04 1995 - 17:19:29 CET