Creating Models › Target Servers for Physical Models › Database Property Editors › Oracle Physical Property Editors › Oracle Materialized View Log Editor › Oracle Materialized View Log Editor - General Tab

Oracle Materialized View Log Editor - General Tab

Use the General tab to assign general options for the materialized view log. The following describes the options available for this tab:

Refresh Types

Select one of the following options:

Primary Key

Sequence

Row ID

Include New Values

Select one of the following options:

INCLUDING

EXCLUDING

Filter Columns

Select the column on which you want to filter by selecting columns from the Available Columns list and adding them to the Selected Columns list.

Available Columns

To add a column to the Selected Columns list, select it and click the button.

Selected Columns

To remove a column from this list and place it back into the Available Columns list, select the column and click the button.

Note: For more information on these parameters, see your vendor's SQL documentation.