Purpose
You can use the ALTER SYSTEM CANCEL RECOVER TABLE statement to cancel ongoing table restores for the target tenant.
Limitations and considerations
This statement cancels all ongoing table restores for the target tenant without releasing the resource pool for the auxiliary tenant.
Table restores that have been completed before you execute this statement cannot be canceled.
Required privileges
Only the root user of the sys tenant (root@sys) can execute this statement.
Syntax
ALTER SYSTEM CANCEL RECOVER TABLE dest_tenant_name;
Parameters
| Parameter | Description |
|---|---|
| dest_tenant_name | The name of the tenant for which you want to cancel ongoing table restores. |
Examples
Cancel table restores for tenant obt in the sys tenant.
obclient [oceanbase]> ALTER SYSTEM CANCEL RECOVER TABLE obt;