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
© Copyright SS64.com 1999-2013
Some rights reserved