The CLEAR_LAST_ARCHIVE_TIMESTAMP procedure is used to clear the last archive timestamp set by the SET_LAST_ARCHIVE_TIMESTAMP procedure.
After the last archive timestamp is cleared, the CLEAN_AUDIT_TRAIL process will no longer be limited by it when cleaning audit records using the last archive timestamp.
Applicability
This content applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support it.
Syntax
DBMS_AUDIT_MGMT.CLEAR_LAST_ARCHIVE_TIMESTAMP(
audit_trail_type IN PLS_INTEGER);
Parameters
Parameter |
Description |
|---|---|
| audit_trail_type | Specifies the type of audit trail for which to clear the last archive timestamp. Valid values:
|