The DROP_SNAPSHOT_RANGE procedure is used to delete a range of snapshots and is only available under the SYS tenant.
Syntax
DBMS_WORKLOAD_REPOSITORY.DROP_SNAPSHOT_RANGE(
low_snap_id INT,
high_snap_id INT
);
Parameters
Parameter |
Description |
|---|---|
| low_snap_id | The ID of the lower snapshot to be deleted. |
| high_snap_id | The ID of the upper snapshot to be deleted. |
Examples
obclient> CALL DBMS_WORKLOAD_REPOSITORY.DROP_SNAPSHOT_RANGE('123','456');
Query OK, 0 rows affected