oracle分割槽索引（二）

          全域性索引只有一類：字首全域性索引

---

---

全域性索引測試程式碼：

詳見註釋，         --在使用我們建立的索引來保證主鍵，所以刪除不掉索引
                             --刪除報的錯誤：ORA-02429:無法刪除用於強制唯一/主鍵的索引

                             --ORA-14038:GLOBAL分割槽索引必須加上字首

drop table partitioned
/
CREATE TABLE partitioned
( timestamp date,
  id        int
)
PARTITION BY RANGE (timestamp)
(
PARTITION part_1 VALUES LESS THAN
( to_date('01-06-2000','dd-mm-yyyy') ) ,
PARTITION part_2 VALUES LESS THAN
( to_date('01-06-2001','dd-mm-yyyy') )
)
/
create index partitioned_index
on partitioned(id)
GLOBAL
partition  by range(id)
(
partition part_1 values less than(1000),
partition part_2 values less than (MAXVALUE)
)
/
alter table partitioned add constraint
partitioned_pk
primary key(id)
/
drop index partitioned_index;--oracle在使用我們建立的索引來保證主鍵，所以刪除不掉索引
                             --刪除報的錯誤：ORA-02429:無法刪除用於強制唯一/主鍵的索引
create index partitioned_index2
on partitioned(timestamp,id)
GLOBAL
partition  by range(id)
(
partition part_1 values less than(1000),
partition part_2 values less than (MAXVALUE)
)--ORA-14038:GLOBAL分割槽索引必須加上字首
/