Oracle Partition - Create Table As

Create Partitioned Table As the Result of a Query

create table MY_TABLE
PARTITION BY RANGE(D_TIME_CODE)
       (PARTITION D_TIME_CODE VALUES LESS THAN ('20100901'),
        PARTITION D_TIME_CODE_2 VALUES LESS THAN ('20150901'))
as select * from myQuery;

Powered by ComboStrap