Oracle Partition - Create Table As

Card Puncher Data Processing

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;







Share this page:
Follow us:
Task Runner