Alter a materialized view log. The word "snapshot" is synonymous
with "materialized view".
Syntax:
ALTER MATERIALIZED VIEW LOG ON [schema.]table options
[PARALLEL int | NOPARALLEL]
Partitioning_options
ADD filter_options
[{INCLUDING|EXCLUDING} NEW VALUES];
Options:
PCTFREE int
PCTUSED int
INITRANS int
MAXTRANS int
STORAGE storage_clause
TABLESPACE tablespace
ALLOCATE EXTENT [( [DATAFILE filename]
[, SIZE int {K | M}]
[, INSTANCE int] )]
LOGGING | NOLOGGING
[CACHE | NOCACHE]
filter_options:
PRIMARY KEY
ROWID
SEQUENCE
(filter_column,…)
multiple filter_options can be separated with commas
“But her friend is nowhere to be seen
Now she walks through her sunken dream
To the seat with the clearest view...” ~ David Bowie (life on Mars)
Related Oracle Commands:
MVIEW - ALTER MATERIALIZED VIEW
MVIEW LOG - CREATE MATERIALIZED VIEW LOG
MVIEW LOG - DROP MATERIALIZED VIEW LOG
Related Views:
DBA_MVIEWS ALL_MVIEWS USER_MVIEWS
DBA_MVIEW_AGGREGATES ALL_MVIEW_AGGREGATES USER_MVIEW_AGGREGATES
DBA_MVIEW_ANALYSIS ALL_MVIEW_ANALYSIS USER_MVIEW_ANALYSIS
DBA_MVIEW_DETAIL_RELATIONS ALL_MVIEW_DETAIL_RELATIONS USER_MVIEW_DETAIL_RELATIONS
DBA_MVIEW_JOINS ALL_MVIEW_JOINS USER_MVIEW_JOINS
DBA_MVIEW_KEYS ALL_MVIEW_KEYS USER_MVIEW_KEYS
DBA_MVIEW_LOGS ALL_MVIEW_LOGS USER_MVIEW_LOGS
DBA_MVIEW_LOG_FILTER_COLS
DBA_MVIEW_REFRESH_TIMES ALL_MVIEW_REFRESH_TIMES USER_MVIEW_REFRESH_TIMES