CREATE TABLE partsample ( prod_id NUMBER(6) , cust_id NUMBER , time_id DATE , channel_id CHAR(1) ) PARTITION BY RANGE (time_id) ( PARTITION PM201508 VALUES LESS THAN (TO_DATE('01.09.2015','DD.MM.YYYY')) TABLESPACE users , PARTITION P20150901 VALUES LESS THAN (TO_DATE('02.09.2015','DD.MM.YYYY')) TABLESPACE users , PARTITION P20150902 VALUES LESS THAN (TO_DATE('03.09.2015','DD.MM.YYYY')) TABLESPACE users , PARTITION P20150903 VALUES LESS THAN (TO_DATE('04.09.2015','DD.MM.YYYY')) TABLESPACE users , PARTITION P20150904 VALUES LESS THAN (TO_DATE('05.09.2015','DD.MM.YYYY')) TABLESPACE users , PARTITION P20150905 VALUES LESS THAN (TO_DATE('06.09.2015','DD.MM.YYYY')) TABLESPACE users ); insert into partsample values (111111,101,TO_DATE('01.09.2015','DD.MM.YYYY'),'1'); insert into partsample values (222222,202,TO_DATE('02.09.2015','DD.MM.YYYY'),'2'); insert into partsample values (333333,303,TO_DATE('03.09.2015','DD.MM.YYYY'),'3'); insert into partsample values (444444,404,TO_DATE('04.09.2015','DD.MM.YYYY'),'4'); insert into partsample values (555555,505,TO_DATE('05.09.2015','DD.MM.YYYY'),'5'); insert into partsample values (666666,606,TO_DATE('28.08.2015','DD.MM.YYYY'),'6'); insert into partsample values (777777,707,TO_DATE('05.04.2015','DD.MM.YYYY'),'7'); commit; select * from partsample; select table_name, partition_name from all_tab_partitions where table_owner = '' order by 1, 2;