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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial