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-36208: (XSAGOP05N) In AGGMAP workspace object, you can only specify NAOPERATOR string with the PROPORTIONAL or EVEN operators, not string.

1 Answers  


ORA-08276: No room in nameserver for pid

1 Answers  


ORA-09344: spsig: error signalling thread

1 Answers  


ORA-02094: replication option not installed

1 Answers  


IMG-00561: input format does not support channel selection

1 Answers  






IMG-00836: area queue merge failed

1 Answers  


NZE-28799: failure to allocate shared memory

1 Answers  


LSX-00161: disallowed type substitution between "~S" and "~S"

1 Answers  


LPX-00110: invalid ~1s "~2S" (not a Name)

1 Answers  


ORA-26085: direct path operation must start its own transaction

1 Answers  


NMP-00008: SNMP message has incorrect version, version 0 is required

1 Answers  


DRG-11828: Conflict

1 Answers  


Categories