|
|
ALTER MATERIALIZED VIEW
Change the properties of an existing mview. - the word "snapshot"
is synonymous with "materialized view".
Syntax:
ALTER MATERIALIZED VIEW [schema.]materialized_view options [USING INDEX index_options] [REFRESH [refresh_options]] [COMPILE | CONSIDER FRESH | {ENABLE|DISABLE} QUERY REWRITE]
options:
LOGGING | NOLOGGING CACHE | NOCACHE PARALLEL int | NOPARALLEL ALLOCATE EXTENT [( [DATAFILE filename] [SIZE int {K | M}] [INSTANCE int] )] Partitioning clause << Note:cannot modify LOB Storage here>> PCTFREE int PCTUSED int INITRANS int MAXTRANS int STORAGE storage_clause index_options INITRANS int MAXTRANS int STORAGE storage_clause refresh_options: FAST | COMPLETE | FORCE ON [DEMAND | COMMIT] {NEXT | START WITH} date WITH PRIMARY KEY USING DEFAULT MASTER ROLLBACK SEGMENT USING MASTER ROLLBACK SEGMENT rb_segment
Related Commands:
GRANT ALTER ANY MATERIALIZED VIEW
MVIEW - CREATE MATERIALIZED VIEW
MVIEW - DROP MATERIALIZED VIEW
MVIEW LOG - ALTER MATERIALIZED VIEW LOG
DBMS_MVIEW
DBMS_REFRESH
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