ORACLE: ALTER MATERIALIZED VIEW LOG [EN]
top of page
CerebroSQL

Oracle:

ALTER MATERIALIZED VIEW LOG

ALTER MATERIALIZED VIEW LOG [ FORCE ]
ON [ schema. ]table
[ physical_attributes_clause
| add_mv_log_column_clause
| alter_table_partitioning
| parallel_clause
| logging_clause
| allocate_extent_clause
| shrink_clause
| move_mv_log_clause
| { CACHE | NOCACHE }
] [ mv_log_augmentation ] [ mv_log_purge_clause ]
;

Example

ALTER MATERIALIZED VIEW LOG ON order_items ADD ROWID;
ALTER MATERIALIZED VIEW LOG ON employees
ADD (commission_pct)
EXCLUDING NEW VALUES;

bottom of page