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.
If the data in the materialized view log (mlog) has not been merged into the materialized view, the PURGE_LOG procedure will not clear this unmerged mlog data. In the case of multiple downstream materialized views, the PURGE_LOG procedure will only clear the mlog data that has been processed by the last materialized view, ensuring the data integrity of all materialized views is not affected.
Applicability
This content applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition only provides MySQL mode.
Syntax
DBMS_MVIEW.PURGE_LOG (
master IN VARCHAR2,
num IN BINARY_INTEGER := 1,
flag IN VARCHAR2 := 'NOP');
Limitations
Applicability
The `num` and `flag` parameters are not supported in this syntax.
Parameters
| Parameter | Description |
|---|---|
| master | The name of the materialized view log whose data needs to be cleared. The format is schema.object or object. |