Change the properties of an existing mview.
The word "snapshot"
is synonymous with "materialized view".
Syntax:
ALTER MATERIALIZED VIEW [schema.]mview options iot_options
[USING INDEX index_options]
[REFRESH [refresh_options]]
[COMPILE | CONSIDER FRESH | {ENABLE|DISABLE} QUERY REWRITE]
ALTER MATERIALIZED VIEW [schema.]mview options iot_options
[USING INDEX index_options]
[REBUILD]
[COMPILE | CONSIDER FRESH | {ENABLE|DISABLE} QUERY REWRITE]
ALTER MATERIALIZED VIEW [schema.]mview options iot_options
[USING INDEX index_options]
MODIFY SCOPE FOR (ref_column/attribute) IS [schema.]scope_table
[COMPILE | CONSIDER FRESH | {ENABLE|DISABLE} QUERY REWRITE]
Options:
COMPRESS|NOCOMPRESS
CACHE | NOCACHE
PARALLEL int | NOPARALLEL
ALLOCATE EXTENT [( [DATAFILE filename]
[, SIZE int {K | M}]
[, INSTANCE int] )]
Partitioning clause
Physical_options
LOB Clause
Physical_options:
PCTFREE int
PCTUSED int
INITRANS int
MAXTRANS int
STORAGE storage_clause
LOGGING | NOLOGGING
iot_options:
[PCTHRESHOLD int ] [INCLUDING column_name]
OVERFLOW [TABLESPACE tablespace] Physical_options
OVERFLOW ALLOCATE EXTENT [( [DATAFILE filename]
[, SIZE int {K | M}]
[, INSTANCE int] )]
OVERFLOW DEALLOCATE UNUSED [KEEP int {K | M}]
ADD OVERFLOW [TABLESPACE tablespace] Physical_options
[(PARTITION [TABLESPACE tablespace] Physical_options)]
COALESCE
index_options:
PCTFREE int
PCTUSED int
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
“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:
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_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