The PURGE_LOG procedure is used to clear materialized view logs, thereby reducing the size of the log files. Clearing materialized view logs will delete all log records related to the table.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition only provides MySQL-compatible mode.
Syntax
PROCEDURE purge_log(
IN master_name VARCHAR(65535));
Parameters
| Parameter | Description |
|---|---|
| master | The name of the materialized view log table from which data needs to be purged. |
The format is schema.object or object. |