ORA-28604: table too fragmented to build bitmap index (string,string,string)

ORA-28604: table too fragmented to build bitmap index (string,string,string)
Cause: The table has one or more blocks that exceed the maximum number of rows expected when creating a bitmap index. This is probably due to deleted rows. The values in the message are: (data block address, slot number found, maximum slot allowed)
Action: Defragment the table or block(s). Use the values in the message to determine the FIRST block affected. (There may be others).

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:48

ORA-28604：表太碎，无法构建位图索引（字符串，字符串，字符串）,
.原因：表中有一个或多个块超过创建位图索引时所需的最大行数。这可能是由于删除的行。消息中的值为：（数据块地址，找到的插槽编号，允许的最大插槽）,
.操作：对表或块进行碎片整理。使用消息中的值确定受影响的第一个块。（可能有其他人）。,
.

aiaiDBA

13718043309

010-86462881

ORA-28604: table too fragmented to build bitmap index (string,string,string)

1 个回答

相似问题