Re: DBMS_REPAIR, 8.1.7

From: DJ <nospamplease_at_goaway.com>
Date: Sat, 22 Nov 2003 18:57:09 -0000
Message-ID: <bkOvb.5292$4Y6.2761@newsfep4-winn.server.ntli.net>

"John Oakes" <john_at_networkproductions.net> wrote in message news:iXNvb.25911$M31.521932_at_twister.tampabay.rr.com...
> I need to recover some data from tables that have bad blocks. I have
> verified they have bad blocks using dbv. I have also identified which
> objects a affected by the corruption. According to the Oracle
> Administrator's Guide, chapter 20, I can mark the table using
> DBMS_REPAIR.SKIP_CORRUPT_BLOCKS, then pull out the data on the good
blocks.
> It also says I can use DBMS_REPAIR.FIX_CORRUPT_BLOCKS to try and repair
> them. I can' find either of these procedures on the server. Should they
> have been installed when Oracle was installed, or do I need to install
some
> sort of additional package? I ran the Oracle installer, but I wasn't able
> to locate an option that wasn't installed that might have the DBMS_REPAIR
> package. What am I missing? Where are these procedures? Thanks for the
> help!
>
> -John
>
>
>
>

what happens when you log in as sys or system and do

desc dbms_repair Received on Sat Nov 22 2003 - 12:57:09 CST