Overview
The DBA_OB_TRANSFER_PARTITION_TASKS view displays the Transfer Partition tasks currently being processed for the current tenant.
The query result of this view is empty because the Transfer Partition operation cannot be performed on user tables under the sys tenant.
Columns
Field |
Type |
Nullable |
Description |
|---|---|---|---|
| TASK_ID | bigint(20) | NO | Unique identifier of the partition transfer task. |
| CREATE_TIME | timestamp(6) | YES | Creation Time |
| MODIFY_TIME | timestamp(6) | YES | Information Update Time |
| TABLE_ID | bigint(20) | NO | Table ID of the partition for which data is being transferred |
| OBJECT_ID | bigint(20) | NO | Partition of Transfer OBJECT_ID |
| DEST_LS | bigint(20) | NO | Destination log stream |
| BALANCE_JOB_ID | bigint(20) | NO | CLB Work ID Associated with Task Execution |
| TRANSFER_TASK_ID | bigint(20) | NO | Transfer task ID associated with the task during execution |
| STATUS | varchar(64) | NO | Task status:
|
| COMMENT | longtext | YES | Comments |
References
View all current partition transfer tasks for all tenants: oceanbase.CDB_OB_TRANSFER_PARTITION_TASKS
View the history of partition transfer tasks executed for the current tenant: oceanbase.DBA_OB_TRANSFER_PARTITION_TASK_HISTORY
For more information about how to transfer a partition, see Transfer Partition.
For more information about Load balancing, see the Data Load Balancing section.