Re: Data Block Corrupted Problem

From: Harold Sasaki <hsasaki_at_harold.com>
Date: 9 Oct 1998 18:37:09 GMT
Message-ID: <6vll4l$q7b$1@nntp2.ba.best.com>

Winnie Liu <oracle_dba_at_zdnetmail.com> wrote:
=> Seriously, in my 2 cents, I don't think that it is possible to fix a
=> corrupted data block for a system datafile. You need to do the recovery for
=> that tablespace

We've gone back through all of our backups (which go back a month) and the corrupted block is in all of them. We didn't notice it affecting anything until recently.

It looks like it's only affecting the "all_constraints" table. We can select from some of the table. Should I try to get what I can out of that table and try to rebuild it?

--

---

Harold Sasaki Received on Fri Oct 09 1998 - 13:37:09 CDT