Note
This view is available starting with V4.2.1 BP2.
Purpose
The DBA_OB_TRANSFER_PARTITION_TASK_HISTORY view displays the history of executed Transfer Partition tasks for the current tenant. Since Transfer Partition operations cannot be performed on user tables under the system tenant, the query results of this view are empty.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| TASK_ID | bigint(20) | NO | The unique identifier of the Transfer Partition task. |
| CREATE_TIME | timestamp(6) | NO | The creation time. |
| FINISH_TIME | timestamp(6) | NO | The completion time of the task, including successful and canceled tasks. |
| TABLE_ID | bigint(20) | NO | The table ID where the partition to be transferred is located. |
| OBJECT_ID | bigint(20) | NO | The OBJECT_ID of the partition to be transferred. |
| DEST_LS | bigint(20) | NO | The log stream of the destination. |
| BALANCE_JOB_ID | bigint(20) | NO | The ID of the load balancing job associated with the task. |
| TRANSFER_TASK_ID | bigint(20) | NO | The ID of the Transfer task associated with the task. |
| STATUS | varchar(64) | NO | The status of the task:
|
| COMMENT | longtext | YES | The comment. |
References
View all Transfer Partition tasks being processed by all tenants: CDB_OB_TRANSFER_PARTITION_TASKS
View the history of executed Transfer Partition tasks for all tenants: CDB_OB_TRANSFER_PARTITION_TASK_HISTORY
For information about Transfer Partition operations, see the following topics: