Note
This view is available starting with V4.0.0.
Purpose
The V$RESTORE_POINT view displays information about restore points.
| Column | Type | Nullable | Description |
|---|---|---|---|
| TENANT_ID | NUMBER(38) | YES | The tenant ID. |
| SCN | NUMBER(38) | NO | The database SCN when the restore point was created. |
| TIME | TIMESTAMP(6) WITH LOCAL TIME ZONE | NO | The time when the restore point was created. |
| NAME | VARCHAR2(512) | YES | The name of the restore point. |
Sample query
Query all restore points in the current tenant.
obclient [SYS]> SELECT * FROM SYS.V$RESTORE_POINT;
The query result is as follows:
+-----------+------------------+------------------------------+-----------+
| TENANT_ID | SNAPSHOT | TIME | NAME |
+-----------+------------------+------------------------------+-----------+
| 1002 | 1710987930807517 | 21-MAR-24 10.25.30.808594 AM | RT_ORACLE |
+-----------+------------------+------------------------------+-----------+
1 row in set