7.3. Using Various Methods to Detect and Resolve Corruption

There are four methods for detecting corruption:

  • The ANALYZE TABLE table_name VALIDATE STRUCTURE command

  • The Oracle DBVERIFY utility used against the offline data files

  • The init.ora parameter DB_BLOCK_CHECKING, which checks data and index blocks each time they are created or modified

  • The DBMS_REPAIR package used against a table, index, or partition

Each method is described in the following sections.

7.3.1. Using the ANALYZE Utility

The ANALYZE TABLE table_name VALIDATE STRUCTURE command validates the integrity of the structure of the object being analyzed. This command is either successful or not successful at the object level. Therefore, if this command returns an error for the object ...

Get OCP: Oracle 10g Administration II Study Guide: Exam 1Z0-043 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.