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
   SEQUENCE
   (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_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


© Copyright SS64.com 1999-2014
Some rights reserved