CREATE MATERIALIZED VIEW LOG ON [schema .] table
[{ physical_attributes_clause
 | TABLESPACE tablespace
 | logging_clause
 | { CACHE | NOCACHE }
 } 
 [ physical_attributes_clause
 | TABLESPACE tablespace
 | logging_clause
 | { CACHE | NOCACHE }
 ]...
]
[parallel_clause] [table_partitioning_clauses]
[WITH 
 { OBJECT ID | PRIMARY KEY | ROWID | SEQUENCE | ( column [, column]... ) } 
 [, { OBJECT ID | PRIMARY KEY | ROWID | SEQUENCE | ( column [, column]... ) }]... 
 [ "new_values_clause" ]
];