Object does not exist. Why? What schema should it be located in?
"DJ" <nospamplease_at_goaway.com> wrote in message
news:bkOvb.5292$4Y6.2761_at_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 - 14:22:58 CST
