DROP RESTORE POINT

Purpose

You can use this statement to drop a restore point.

Notice

You cannot create or drop restore points in the SYS tenant.

Syntax

DROP RESTORE POINT restore_point;

Parameters

Examples

1. Query the existing restore points of a tenant.

   obclient> SELECT * FROM V$RESTORE_POINT;
   +-----------+------------------+----------------------------+------+
    TENANT_ID  SNAPSHOT          TIME                        NAME 
   +-----------+------------------+----------------------------+------+
         1001  1630407064663511  2021-08-31 18:51:04.665692  rp1  
   +-----------+------------------+----------------------------+------+
   1 row in set (0.01 sec)
   

2. Drop the restore point rp1.

   obclient> DROP RESTORE POINT rp1;
   Query OK, 0 rows affected (0.01 sec)