Has anyone encountered a data corruption error when running
Oracle 7.1.6 on HP SUN UNIX?
I'll get the error code but it basically comes down to
a corruption that occurs sporadically in a rather large data
warehouse. It has been found that the corruption is narrowed to
a specific row in the table. Selecting up to and after the row
(using rowid > and rowid < ) does not cause any problem, but
any selects which involve table scans brings up the error
apparently because Oracle passes over the corrupted part of
the table.
Oracle's answer to this is to select out of the table, drop it,
recreate it and reload it. This would be fine for a small table,
but for one with 5 million rows, this isn't acceptable, since the
whole workaround takes umpteen hours. And the corrupted data
is lost.
I'm sorry I don't have the error number on hand. I'll try and repost
with it.
Thanks in advance
J Tseng
tseng_at_execpc.com