CREATE MATERIALIZED VIEW LOG

Create a materialized view log - a table containing the query result of a materialized view. The word "snapshot" is synonymous with "materialized view".

Syntax:

   CREATE MATERIALIZED VIEW LOG ON [schema.]table options
      [PARALLEL int | NOPARALLEL]
          Partitioning_options 
             WITH filter_option(s)
                [{INCLUDING|EXCLUDING} NEW VALUES];

options:

   PCTFREE int
   PCTUSED int
   INITRANS int
   MAXTRANS int
   STORAGE storage_clause
   TABLESPACE tablespace
   LOGGING | NOLOGGING
   [CACHE | NOCACHE]

filter_options:
   [{PRIMARY KEY | rowid}] (filter_column,...)
   
   multiple filter_options can be separated with commas

Related Commands:

MVIEW - CREATE MATERIALIZED VIEW
MVIEW - ALTER MATERIALIZED VIEW LOG
MVIEW - 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