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
Received on Sat Nov 22 2003 - 12:30:38 CST
