The DBMS_MVIEW system package is used to refresh materialized views and purge materialized view logs.
Overview of DBMS_MVIEW Subprograms
The following table lists the DBMS_MVIEW subprograms supported by the current version of OceanBase AI Database and provides brief descriptions.
subprogram |
Description |
|---|---|
| PURGE_LOG | This statement is used to purge materialized view logs. Purging materialized view logs deletes all log records related to the table. |
| REFRESH | Refreshes one or more specified materialized views. |
| KILL_REFRESH | This API is used to actively terminate a materialized view refresh batch that is still in progress and managed by the new scheduling framework. |
| REFRESH_REPORT | Generates a hierarchical diagnostic report for a single materialized view refresh task. |