The PURGE_LOG procedure is used to clear materialized view logs to reduce the size of 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 provides only MySQL mode.
Syntax
PROCEDURE purge_log(
IN master_name VARCHAR(65535));
Parameters
| Parameter | Description |
|---|---|
| master | The name of the primary table whose materialized view logs need to be cleared. |
The format is schema.object or object. |