我刚才建立了本地索引分区
create table Result(
id number,
result number
)
partition by range(result)(
partition r_1 values less than (60)
tablespace space1,
partition r_2 values less than (80)
tablespace space2,
partition r_3 values less than (maxvalue)
tablespace space3
);
create index r_index on Result(result) local(
partition r_1 tablespace space1,
partition r_2 tablespace space2,
partition r_3 tablespace space3
);测试数据
insert into Result values(1,50);
insert into Result values(2,54);
insert into Result values(3,70);
insert into Result values(4,80);
insert into Result values(5,90);上面没有报错。可是我想查分区的信息的时候
select result from result partition(space1);//不行求大虾解释,帮助
create table Result(
id number,
result number
)
partition by range(result)(
partition r_1 values less than (60)
tablespace space1,
partition r_2 values less than (80)
tablespace space2,
partition r_3 values less than (maxvalue)
tablespace space3
);
create index r_index on Result(result) local(
partition r_1 tablespace space1,
partition r_2 tablespace space2,
partition r_3 tablespace space3
);测试数据
insert into Result values(1,50);
insert into Result values(2,54);
insert into Result values(3,70);
insert into Result values(4,80);
insert into Result values(5,90);上面没有报错。可是我想查分区的信息的时候
select result from result partition(space1);//不行求大虾解释,帮助
select * from 表 partition(分区名称)select result from result partition(r_1);