分区表的bitmap索引,必须是 local的,不能是global的
create table t_par (id number,name varchar2(10))
partition by range (id)
(partition p1 values less than(10),
partition p2 values less than(20),
partition p3 values less than(maxvalue)
);
SQL> create bitmap index idx_t_par on t_par(name) local;
Index created.
SQL> drop index idx_t_par;
Index dropped.
SQL> create bitmap index idx_t_par on t_par(name) ; --不是分区的bitmap索引就会报错
create bitmap index idx_t_par on t_par(name)
*
ERROR at line 1:
ORA-25122: Only LOCAL bitmap indexes are permitted on partitioned tables
by song
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25099483/viewspace-772176/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/25099483/viewspace-772176/