- 在创建索引时如果不显式指定global或local,则默认是global。
- 在创建global索引时如果不显式指定分区子句,则默认不分区(废话)。
--创建测试表
DROP TABLE t_part;create table t_part(object_id int,object_name varchar2(1000)) partition by range(object_id)
(
partition p1 values less than (1000),
partition p2 values less than (2000),
partition p3 values less than (3000),
partition p4 values less than (4000),
partition pm values less than (maxvalue)
);
--插入测试数据
INSERT INTO t_part SELECT ROWNUM,t.index_name FROM dba_indexes t;
commit;
create index idx_part_local on t_part(object_name) local;
--创建全局非分区索引
create index idx_part_global on t_part(object_id) global;
--删除分区前查询索引状态&#