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 ]
  ] ;