The DROP_SNAPSHOT_RANGE procedure deletes snapshots within the specified range and is available only in 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 minimum ID of snapshots to be dropped. |
| high_snap_id | The maximum ID of snapshots to be dropped. |
Examples
obclient> CALL DBMS_WORKLOAD_REPOSITORY.DROP_SNAPSHOT_RANGE('123','456');
Query OK, 0 rows affected