Oracle数据库表范围分区策略测试过程

/*该试验针对按照递增列作为分区条件的情况，按照时间作为分区条件的等下次测试*/

bordercolorlight = "black" bordercolordark = "#FFFFFF" align="center"

create tablespace test01 datafile "D:oracleoradatamyoraest01.dbf"size 50m;

create tablespace test02 datafile "D:oracleoradatamyoraest02.dbf"size 50m;

create tablespace test03 datafile "D:oracleoradatamyoraest03.dbf"size 50m;

create tablespace test_idx01 datafile "D:oracleoradatamyoraest_idx01.dbf"size 20m;

create tablespace test_idx02 datafile "D:oracleoradatamyoraest_idx02.dbf"size 20m;

create tablespace test_idx03 datafile "D:oracleoradatamyoraest_idx03.dbf"size 20m;

Create table test (

aa integer,

bb varchar2(100)

)

partition by rang(aa)(

Partition part_01 values less than(10000) Tablespace test_idx01,

Partition part_02 values less than(30000) Tablespace test_idx02,

Partition part_03 values less than(maxvalue)Tablespace test_idx03

);

Create Index idx_test_aa On test(aa)Local

(

Partition part_01 Tablespace test_idx01,

Partition part_02 Tablespace test_idx02,

Partition part_03 Tablespace test_idx03

);

-- Create sequence

create sequence seq_test_aa

minvalue 1

maxvalue 60000

start with 1

increment by 1

cache 10;

insert into test values(seq_test_aa.nextval,"test