Note
This view is available starting with V4.0.0.
Overview
Displays column validation and inconsistency information between index tables (including global and local indexes) and the primary table.
Columns
Field |
Type |
Nullable |
Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | Tenant ID |
| FROZEN_SCN | bigint(20) unsigned | NO | SCN of the Current Major Compaction |
| INDEX_TYPE | varchar(12) | NO | Index table type. Valid values:
|
| DATA_TABLE_ID | bigint(20) | NO | Primary Table ID |
| INDEX_TABLE_ID | bigint(20) | NO | Global/Local Index Table ID |
| DATA_TABLET_ID | bigint(20) | NO | Tablet IDs with inconsistent checksums appear in the primary table (only for verification between local index tables and the primary table). |
| INDEX_TABLET_ID | bigint(20) | NO | Tablet IDs with inconsistent checksums found in the index table (only for verification between local index tables and the primary table) |
| COLUMN_ID | bigint(20) | NO | ID of the column with the checksum error |
| DATA_COLUMN_CHECKSUM | bigint(20) | NO | Column checksum value of the primary table |
| INDEX_COLUMN_CHECKSUM | bigint(20) | NO | The column checksum value of the index column |