/*该试验针对按照递增列作为分区条件的情况，按照时间作为分区条件的等下次测试*/
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
