DROP_SNAPSHOT_RANGE

The DROP_SNAPSHOT_RANGE procedure is used to delete a range of snapshots.

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 higher snapshot to be deleted.

Examples

CALL DBMS_WORKLOAD_REPOSITORY.DROP_SNAPSHOT_RANGE('123','456');
Query OK, 0 rows affected