CREATE INDEX prod_idx ON product_information_part(product_id) LOCAL STORE IN (tbs_1, tbs_2);
create table tmp_p ( ticket_id number(12) not null, partition_id number(2) not null ) storage (initial 512K next 512K pctincrease 0) partition by range (partition_id) (partition tmp_p_0 values less than (1), partition tmp_p_9 values less than (maxvalue));我的表按以上方式建立,我只想在tmp_p_9分区上在ticket_id建索引,应该怎么办呢?谢谢
create index tmp_p_9 _i on tmp_p(partition_id) local (PARTITION tmp_p_9 TABLESPACE TS_IND_name;
STORE IN (tbs_1, tbs_2);
(
ticket_id number(12) not null,
partition_id number(2) not null
)
storage (initial 512K next 512K pctincrease 0)
partition by range (partition_id)
(partition tmp_p_0 values less than (1),
partition tmp_p_9 values less than (maxvalue));我的表按以上方式建立,我只想在tmp_p_9分区上在ticket_id建索引,应该怎么办呢?谢谢
(PARTITION tmp_p_9 TABLESPACE TS_IND_name;