Note
This view is available starting with V4.6.0.
Purpose
The DBA_OB_LOB_CHECK_EXCEPTION_RESULT view displays the abnormal tables and tablets for LOB consistency check, along with the exception types, under the current tenant.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| TENANT_ID | NUMBER(38) | NO | Tenant ID |
| LS_ID | NUMBER(38) | NO | Log Stream ID |
| CREATE_TIME | TIMESTAMP(6) WITH LOCAL TIME ZON | NO | Exception Result Creation Time |
| UPDATE_TIME | TIMESTAMP(6) WITH LOCAL TIME ZON | NO | Modified At of Exceptional Result |
| TABLE_NAME | VARCHAR2(256) | NO | Abnormal Table Name |
| TABLE_ID | NUMBER(38) | NO | ID of the abnormal table object |
| INCONSISTENCY_TYPE | VARCHAR2(16) | NO | Exception type.
|
| TABLET_IDS | CLOB | NO | Exception partition ID |
| TASK_SCOPE | VARCHAR2(6) | NO | Task type. Valid values:
|
Sample query
obclient > SELECT * FROM DBA_OB_LOB_CHECK_EXCEPTION_RESULT;