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 materialized-query-definition 1? ( 1.1 column-name 1.1.1? FOR 1.1.1.1! COLUMN 1.1.1.2 system-column-name 1.1.1.3 ) 2 AS ( select-statement ) refreshable-table-options refreshable-table-options 1 DATA INITIALLY DEFERRED 1 DATA INITIALLY IMMEDIATE 2 REFRESH DEFERRED 3+ 3 (1) MAINTAINED BY USER 3! ENABLE QUERY OPTIMIZATION 3 DISABLE QUERY OPTIMIZATION 4