The PURGE_LOG procedure purges materialized view logs to reduce the size of the log file. This operation will delete all materialized view logs related to the specified master table (base table).
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Syntax
PROCEDURE purge_log(
IN master_name VARCHAR(65535));
Parameters
| Parameter | Description |
|---|---|
| master | The name of the master table for which you want to purge logs, in the format of schema.object or object. |