Create table template
create table
( col1 number,
col2 number,
..... )
partition by range ( col1, col2 )
( partition p1 values less than (...,... ) tablespace p1,
partition p2 values less than (...,... ) tablespace p2);
Related examples in the same category