select into

The select into syntax has been extended to create an index compressed table by selecting from an existing table.

Syntax

select [ all | distinct ] select_list
    into [[database.][owner].table_name
    [with {max_rows_per_page = num_rows,          
        exp_row_size = num_bytes,       
        reservepagegap = num_pages,        
        identity_gap = value,           
        transfer table [on | off],    
        compression [={NONE | PAGE | ROW | ALL} ] ,
        index_compression [={NONE | PAGE} ]     
        }           
    ]   
    [on segment_name]

Parameter Changes

NONE – indexes on the specified table are not compressed. Indexes that are specifically created with index_compression = PAGE are compressed.
PAGE – all indexes on the specified table are compressed. Indexes that are specifically created with index_compression = NONE are not compressed.