PL/SQL Packages DBMS_REPAIR

Data corruption repair procedures that enable you to detect and repair corrupt blocks in tables and indexes.

Subprocedures:

ADMIN_TABLES        Provides administrative functions for the DBMS_REPAIR
                    package repair and orphan key tables, including create,
                    purge, and drop functions. 

CHECK_OBJECT        Detect and report corruptions in a table or index. 

DUMP_ORPHAN_KEYS    Report on index entries that point to rows in corrupt
                    data blocks. 

FIX_CORRUPT_BLOCKS  Mark blocks as software corrupt that have been previously
                    detected as corrupt by CHECK_OBJECT. 

REBUILD_FREELISTS   Rebuild an object's freelists. 

SKIP_CORRUPT_BLOCKS Set whether to ignore blocks marked corrupt during table
                    and index scans or to report ORA-1578 when blocks marked
                    corrupt are encountered. 

SEGMENT_FIX_STATUS  Fix the corrupted state of a bitmap entry.  

For full documentation of the packaged procedures above see the Oracle Manual:
"Oracle9i Supplied PL/SQL Packages and Types Reference"

or the book Oracle Built in Packages by Steven Feuerstein et al

Related Commands:

Related Packages: