Note
This view is available starting with V4.2.1 BP2.
Purpose
The DBA_OB_TRANSFER_PARTITION_TASKS view displays the Transfer Partition tasks being processed in the current tenant.
Since Transfer Partition operations cannot be performed on user tables in the sys 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 being transferred. |
| OBJECT_ID | bigint(20) | NO | The OBJECT_ID of the partition being 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 the Transfer Partition tasks being processed in all tenants: oceanbase.CDB_OB_TRANSFER_PARTITION_TASKS
View the history of Transfer Partition tasks executed in the current tenant: oceanbase.DBA_OB_TRANSFER_PARTITION_TASK_HISTORY
For more information about how to perform Transfer Partition operations, see Transfer Partition.
For more information about how to perform data load balancing operations, see Data load balancing.