Re: Data corruption error
From: Salahuddin Faruqui <BTJV84A_at_prodigy.com>
Date: 1996/07/11
Message-ID: <4s248g$1bj8_at_useneta1.news.prodigy.com>#1/1
Date: 1996/07/11
Message-ID: <4s248g$1bj8_at_useneta1.news.prodigy.com>#1/1
Hi Tseng
ORA-600 is usually accompanied by the "Data block corrupted" message. If
you have an issue of "Oracle Integrator" (Jan-Feb '96) it contained an
article on this subject. The process is lengthy but if you have an index
on the table then almost all of the data is recoverable, by selecting the
indexed columns of the corrupt row(s) only and subsequently the entire
table (and dumping both into temp tables).
-
Obaid A. Faruqi
Received on Thu Jul 11 1996 - 00:00:00 CEST