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



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

Answer / guest

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=<table_name> AND owner# = <table_owner>; commit;

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-27102: out of memory

1 Answers  


ORA-39079: unable to enqueue message string

1 Answers  


NNL-00342: Log file name is currently string

1 Answers  


ORA-38403: attribute set name may not be longer than 22 characters

1 Answers  


DRG-50861: failed to obtain type descriptor

1 Answers  






NNO-00322: statistic counter dump interval changed to number seconds

1 Answers  


ORA-10618: Operation not allowed on this segment

1 Answers  


IMG-00861: assert failure, inconsistency in area merge operation

1 Answers  


ORA-08312: sllfop: unrecognized processing option

1 Answers  


ORA-04940: unsupported optimization of Oracle binary, check alert log for more info

1 Answers  


ORA-24809: amount specified will not fit in the lob buffers

1 Answers  


EXP-00053: unable to execute QUERY on table string because the table has inner nested tables

1 Answers  


Categories