Note
This view is available starting with V4.0.0.
Purpose
This view displays the cleanup policies set for tenant-level expiration and automatic cleanup.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| POLICY_NAME | VARCHAR2(256) | NO | The name of the cleanup policy. |
| RECOVERY_WINDOW | VARCHAR2(64) | NO | The time window for data recovery. The default value is 0. |
Sample query
Query the cleanup policy of the user tenant.
obclient [SYS]> SELECT * FROM SYS.DBA_OB_BACKUP_DELETE_POLICY;
The query result is as follows:
+-------------+-----------------+
| POLICY_NAME | RECOVERY_WINDOW |
+-------------+-----------------+
| default | 7d |
+-------------+-----------------+
1 row in set