Re: Data Block Corrupted Problem

Since it is a system tables (all_constraints), I don't think it is wise to try to recover whatever you can out of that table using rowid lookup. You can do that with other data table, but I would not suggest to use that for the system table, you may end up corrupting the system tables. Also, all_constraints is only a view, it mean that it is actually affecting those base table like x$XXXXX. What I will suggest you to do (since all your backup is not usable) is to export the whole database and rebuild it again.

Winnie

Harold Sasaki wrote in message <6vll4l$q7b$1_at_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 - 21:22:22 CDT