ORA-28606: block too fragmented to build bitmap index (string,string)

ORA-28606: block too fragmented to build bitmap index (string,string)
Cause: The block(s) exceed the maximum number of rows expected when creating a bitmap index. This is probably due to maximum slot allowed set too low. The values in the message are: (slot number found, maximum slot allowed)
Action: alter system flush shared_pool; update tab$ set spare1 = 8192 where obj# = (select obj# from obj$ where NAME= AND owner# = ; commit;

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:48

ORA-28606：块太碎，无法构建位图索引（字符串，字符串）,
.原因：创建位图索引时，块超出了预期的最大行数。这可能是由于最大插槽允许设置太低。消息中的值为：（找到的插槽编号，允许的最大插槽）,
.操作： alter system flush shared_pool; 更新标签$ set spare1 = 8192其中obj＃=（select obj＃from obj $其中NAME = AND owner＃= ; commit;,
.

aiaiDBA

13718043309

010-86462881

ORA-28606: block too fragmented to build bitmap index (string,string)

1 个回答

相似问题