1.

How Can You Detect Block Corruption?

Answer»

There are four methods for detecting block corruption, which are given as follows:

  1. The ANALYZE_TABLE <table_name> VALIDATE STRUCTURE COMMAND
  2. The Oracle DBVERIFY utility against the offline datafiles
  3. The init.ora parameter DB_BLOCK_CHECKING, WHIHC checks data and index_blocks each time they are CREATED or MODIFIED.
  4. THE DBMS_REPAIR PACKAGES used against a table, index or partition.

There are four methods for detecting block corruption, which are given as follows:


Discussion

No Comment Found

Related InterviewSolutions