Purpose
You can use the ALTER SYSTEM CANCEL RECOVER TABLE statement to cancel the ongoing table-level restore jobs of the target tenant.
Limitations and considerations
This statement will cancel all table-level restore jobs in the corresponding tenant but will not release the resource pool created for the auxiliary tenant.
If some tables have been restored before you execute this statement, you cannot cancel the restore of these tables.
Required privileges
You can execute the ALTER SYSTEM RECOVER TABLE statement only as the root user of the sys tenant (namely root@sys).
Syntax
ALTER SYSTEM CANCEL RECOVER TABLE dest_tenant_name;
Parameters
| Parameter | Description |
|---|---|
| dest_tenant_name | The target tenant for which table-level restore is being performed. |
Examples
Cancel the table-level restore jobs of the obt tenant from the sys tenant.
obclient [oceanbase]> ALTER SYSTEM CANCEL RECOVER TABLE obt;