Purpose
The ALTER SYSTEM CANCEL RECOVER TABLE statement is used to cancel the table-level recovery task of the target tenant.
Limitations and considerations
Executing this statement will cancel all table-level recovery tasks for the corresponding tenant, but will not release the resource pools created for the auxiliary tenant.
If some tables have already been recovered before executing this statement, the recovery of those tables cannot be canceled.
Privilege requirements
Only the root user of the sys tenant (root@sys) can execute the ALTER SYSTEM RECOVER TABLE statement.
Syntax
ALTER SYSTEM CANCEL RECOVER TABLE dest_tenant_name;
Parameters
| Parameter | Description |
|---|---|
| dest_tenant_name | Specifies the target tenant for which the table-level recovery task is being canceled. |
Examples
In the sys tenant, cancel the table-level recovery task of the target tenant obt.
obclient [oceanbase]> ALTER SYSTEM CANCEL RECOVER TABLE obt;