Note
This view is available starting with V4.0.0.
Purpose
This view displays information about column checksum inconsistencies between index tables (global and local) and the primary table.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The tenant ID. |
| FROZEN_SCN | bigint(20) unsigned | NO | The current merge SCN. |
| INDEX_TYPE | varchar(12) | NO | The type of the index table.
|
| DATA_TABLE_ID | bigint(20) | NO | The ID of the primary table. |
| INDEX_TABLE_ID | bigint(20) | NO | The ID of the global or local index table. |
| DATA_TABLET_ID | bigint(20) | NO | The ID of the tablet on the primary table where the checksum inconsistency occurs. This field is applicable only to local index tables and the primary table. |
| INDEX_TABLET_ID | bigint(20) | NO | The ID of the tablet on the index table where the checksum inconsistency occurs. This field is applicable only to local index tables and the primary table. |
| COLUMN_ID | bigint(20) | NO | The ID of the column where the checksum error occurs. |
| DATA_COLUMN_CHECKSUM | bigint(20) | NO | The column checksum value of the column on the primary table. |
| INDEX_COLUMN_CHECKSUM | bigint(20) | NO | The column checksum value of the column on the index table. |