|
|
ALTER MATERIALIZED VIEW LOG
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}] (filter_column,...) multiple filter_options can be separated with commas
Related 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_SNAPSHOTS ALL_SNAPSHOTS USER_SNAPSHOTS DBA_SNAPSHOT_LOGS ALL_SNAPSHOT_LOGS USER_SNAPSHOT_LOGS DBA_SNAPSHOT_LOG_FILTER_COLS DBA_SNAPSHOT_REFRESH_TIMES ALL_SNAPSHOT_REFRESH_TIMES USER_SNAPSHOT_REFRESH_TIMES