materialized-query-definition:

1 ( select-statement ) refreshable-table-options

refreshable-table-options:

1 DATA INITIALLY DEFERRED
1 DATA INITIALLY IMMEDIATE
2 REFRESH DEFERRED
3+ 
3 MAINTAINED BY USER
3 ENABLE QUERY OPTIMIZATION
3 DISABLE QUERY OPTIMIZATION
4 (1) 


materialized-query-table-alteration:

1 ( select-statement )
1.1? refreshable-table-options
1 SET
1.1.0+ 
1.1.0 REFRESH DEFERRED
1.1.0 MAINTAINED BY USER
1.1.0 ENABLE QUERY OPTIMIZATION
1.1.0 DISABLE QUERY OPTIMIZATION
1.1.1 (2)