CREATE MATERIALIZED VIEW LOG ON [schema .] table
[{ physical_attributes_clause
 | TABLESPACE tablespace
 | { LOGGING | NOLOGGING }
 | { CACHE | NOCACHE }
 } 
 [ physical_attributes_clause
 | TABLESPACE tablespace
 | { LOGGING | NOLOGGING }
 | { CACHE | NOCACHE }
 ]...
]
[parallel_clause] [partitioning_clauses]
[WITH 
 { OBJECT ID | PRIMARY KEY | ROWID | SEQUENCE | ( column [, column]... ) } 
 [, { OBJECT ID | PRIMARY KEY | ROWID | SEQUENCE | ( column [, column]... ) }]... 
] 
[{ INCLUDING | EXCLUDING } NEW VALUES];

For information on the symbols and conventions of Backus-Naur Form (BNF) syntax, see Appendix A.