range 范围分区 典型的
给你个简单的参考
create table table_name
(
col1 varchar2(255) ,
col2 varchar2(255),
create_date date
)
partition by range(create_date)
(
partition patition_name1 values less than (to_date('2014/2/1','yyyy/mm/dd')),
partition patition_name2 values less than (to_date('2014/3/1','yyyy/mm/dd')),
/*以此类推分区3/分区4/分区5/分区6............ 主意不要忘记加上 partition patition_max values less than (maxvalue)*/
partition patition_max values less than (maxvalue)
)
给你个简单的参考
create table table_name
(
col1 varchar2(255) ,
col2 varchar2(255),
create_date date
)
partition by range(create_date)
(
partition patition_name1 values less than (to_date('2014/2/1','yyyy/mm/dd')),
partition patition_name2 values less than (to_date('2014/3/1','yyyy/mm/dd')),
/*以此类推分区3/分区4/分区5/分区6............ 主意不要忘记加上 partition patition_max values less than (maxvalue)*/
partition patition_max values less than (maxvalue)
)
http://www.itpub.net/thread-883690-1-1.html自己也做了试验,10201 和11203 好像都不支持