DROP_SNAPSHOT_RANGE

2026-02-11 07:43:39  Updated

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

Contact Us