How Would You Check That A Given Index Is Consistent And Has No Corru

1.	How Would You Check That A Given Index Is Consistent And Has No Corruption? If Corruption Occurred On A Database What Would Your Process Be?
Answer» Index (ALONG with database and table) consistency can be verified with oncheck -CDI database_name:table_name. Preferably with the instance put in quiescent mode. If just the index is CORRUPTED (and not fixable by oncheck), an OPTION will be to recreate the index.

How Would You Check That A Given Index Is Consistent And Has No Corruption? If Corruption Occurred On A Database What Would Your Process Be?

Answer»

Index (ALONG with database and table) consistency can be verified with oncheck -CDI database_name:table_name. Preferably with the instance put in quiescent mode.
If just the index is CORRUPTED (and not fixable by oncheck), an OPTION will be to recreate the index.