prorm API Reference
    Preparing search index...

    Interface MaterializedViewLogOptions

    Options for creating/dropping a materialized view log (Oracle).

    A materialized view log is created on a master table (not on the materialized view itself) and is a prerequisite for FAST (incremental) refresh of any materialized view built on that table - without a log, REFRESH FAST fails with ORA-23413 ("table does not have a materialized view log").

    Oracle syntax:

    CREATE MATERIALIZED VIEW LOG ON table_name
      [WITH [ROWID] [, PRIMARY KEY] [, SEQUENCE] [(col1, col2, ...)] [INCLUDING NEW VALUES]]
    DROP MATERIALIZED VIEW LOG ON table_name
    interface MaterializedViewLogOptions {
        schema?: string;
        withRowid?: boolean;
        withPrimaryKey?: boolean;
        sequence?: boolean;
        columns?: string[];
        includingNewValues?: boolean;
    }
    Index
    schema? withRowid? withPrimaryKey? sequence? columns? includingNewValues?
    schema?: string

    Schema the master table (and resulting log) belongs to.

    withRowid?: boolean

    Include ROWID in the log (WITH ROWID). Required for fast refresh of materialized views without a primary key, or that use ROWID as the join/lookup key.

    withPrimaryKey?: boolean

    Include the primary key in the log (WITH PRIMARY KEY). This is Oracle's own default when neither withRowid nor withPrimaryKey is specified, so this library defaults to it as well when nothing is set.

    sequence?: boolean

    Include a SEQUENCE value in the log (WITH ... SEQUENCE). Required for fast refresh of materialized views that involve joins or set operators such as UNION.

    columns?: string[]

    Specific filter columns to log in addition to the logging key (WITH ... (col1, col2, ...)). Needed for fast refresh of materialized views that aggregate or reference specific columns.

    includingNewValues?: boolean

    Log the new values of columns, not just old values (INCLUDING NEW VALUES). Required for fast refresh of materialized views containing aggregate functions. Defaults to true since that is the common case for fast-refreshable materialized views.

    Settings
    Member Visibility

    On This Page
    Properties