LOG_OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the materialized view log |
MASTER |
VARCHAR2(30) |
NOT NULL |
Name of the master table or master materialized view whose changes are logged |
LOG_TABLE |
VARCHAR2(30) |
NOT NULL |
Name of the table where the changes to the master table or master materialized view are logged |
LOG_TRIGGER |
VARCHAR2(30) |
|
Obsolete with the release of Oracle8i and higher. Set to NULL . Formerly, this parameter was an after-row trigger on the master which inserted rows into the log. |
ROWIDS |
VARCHAR2(3) |
|
If YES , records rowid information |
PRIMARY_KEY |
VARCHAR2(3) |
|
If YES , records primary key information |
OBJECT_ID |
VARCHAR2(3) |
|
If YES , records object identifier information in an object table |
FILTER_COLUMNS |
VARCHAR2(3) |
|
If YES , records filter columns |
SEQUENCE |
VARCHAR2(3) |
|
If YES , records the sequence value, which provides additional ordering information |
INCLUDE_NEW_VALUES |
VARCHAR2(3) |
|
If YES , records both old and new values. If NO , records old values, but does not record new values. |