Skip to main content
Version: V1.0.0

Overview of DBMS_MVIEW

The DBMS_MVIEW package is used to refresh materialized views and drop materialized view logs.

Overview of DBMS_MVIEW subprograms

The following table lists the DBMS_MVIEW subprograms supported by seekdb and a brief description of each.

SubprogramDescription
PURGE_LOGUsed to drop a materialized view log. Dropping a materialized view log deletes all log records associated with the table.
REFRESHRefreshes one or more specified materialized views.