ALTER MATERIALIZED VIEW LOG ON [schema .] table
[ physical_attributes_clause 
| alter_table_partitioning
| parallel_clause 
| logging_clause
| allocate_extent_clause
| { CACHE | NOCACHE } 
] 
[ADD
 { { OBJECT ID | PRIMARY KEY | ROWID } [( column [, column]... )]
 | ( column [, column]... )
 }
 [, { { OBJECT ID | PRIMARY KEY | ROWID } [( column [, column]... )]
    | ( column [, column]... )
    }
 ]... 
 [ new_values_clause ] 
];