Note
This view is available starting with V4.2.1 BP2.
Purpose
The DBA_OB_TRANSFER_PARTITION_TASKS view displays the Transfer Partition tasks that are being processed in the current tenant.
Since Transfer Partition operations cannot be performed on user tables in the system tenant, the query result of this view is empty.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| TASK_ID | bigint(20) | NO | The unique identifier of the Transfer Partition task. |
| CREATE_TIME | timestamp(6) | YES | The time when the task was created. |
| MODIFY_TIME | timestamp(6) | YES | The time when the information was last updated. |
| TABLE_ID | bigint(20) | NO | The ID of the table that contains the partition to be transferred. |
| 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. Valid values:
|
| COMMENT | longtext | YES | The comment. |
References
View all Transfer Partition tasks that are being processed in all tenants: oceanbase.CDB_OB_TRANSFER_PARTITION_TASKS
View the history of Transfer Partition tasks that have been executed in the current tenant: oceanbase.DBA_OB_TRANSFER_PARTITION_TASK_HISTORY
For more information about Transfer Partition operations, see Transfer Partition.
For more information about data load balancing, see Data load balancing.