Purpose
You can use this statement to cancel ongoing table restores for a tenant. Table restores that have been completed cannot be canceled.
You can execute this statement only in the sys tenant.
Syntax
ALTER SYSTEM CANCEL RECOVER TABLE dest_tenant_name;
Parameters
dest_tenant_name specifies the name of the tenant whose ongoing table restores are to be canceled.
Examples
Cancel ongoing table restores for the obt tenant.
ALTER SYSTEM CANCEL RECOVER TABLE obt;