ending-clause 1 ENDING 2! AT 3 ( 3.1+ , 3.1.0 constant 3.1.0 MINVALUE 3.1.0 MAXVALUE 3.2 ) 3 constant 3 MINVALUE 3 MAXVALUE 4! INCLUSIVE 4? 4 EXCLUSIVE hash-partition-spec 1 ( 2+ , 2 column-name 3 ) INTO integer PARTITIONS add-partition 1? partition-name 1.1 boundary-spec 1.2? media-preference 1 integer 1.1 HASH PARTITIONS 1.1 HASH PARTITION 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)