ALTER MATERIALIZED VIEW
[ schema. ] materialized_view
[ physical_attributes_clause
| modify_mv_column_clause
| table_compression
| LOB_storage_clause [, LOB_storage_clause ]...
| modify_LOB_storage_clause [, modify_LOB_storage_clause ]...
| alter_table_partitioning
| parallel_clause
| logging_clause
| allocate_extent_clause
| deallocate_unused_clause
| shrink_clause
| { CACHE | NOCACHE }
]
[ alter_iot_clauses ]
[ USING INDEX physical_attributes_clause ]
[ MODIFY scoped_table_ref_constraint
| alter_mv_refresh
]
[ { ENABLE | DISABLE } QUERY REWRITE
| COMPILE
| CONSIDER FRESH
] ;
example
ALTER MATERIALIZED VIEW sales_by_month_by_state
REFRESH FAST;
ALTER MATERIALIZED VIEW sales_by_month_by_state
REFRESH NEXT SYSDATE+7;
ALTER MATERIALIZED VIEW sales_by_month_by_state CONSIDER FRESH;
ALTER MATERIALIZED VIEW emp_data
REFRESH COMPLETE
START WITH TRUNC(SYSDATE+1) + 9/24
NEXT SYSDATE+7;
ALTER MATERIALIZED VIEW emp_data
ENABLE QUERY REWRITE;
ALTER MATERIALIZED VIEW order_data
REFRESH WITH PRIMARY KEY;
ALTER MATERIALIZED VIEW order_data COMPILE;