create table ytable (
id number not null,
name varchar2(2)
)
partition by range (id )
(
partition p1 values less than (3) tablespace DATA001,
partition p2 values less than (6) tablespace INX001,
partition p3 values less than (7) tablespace D_DATA,
partition p4 values less than (maxvalue) tablespace SYSTEM
);