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

SQL*Loader-00647: Integer to number conversion error

1 Answers  


DRG-52103: the Oracle Text environment could not reset

1 Answers  


ORA-02442: Cannot drop nonexistent unique key

1 Answers  


ORA-09719: osncui: invalid handle.

1 Answers  


ORA-23320: the request failed because of values string and string

1 Answers  


ORA-24033: no recipients for message

1 Answers  


IMG-00557: invalid value for contrast enhancement

1 Answers  


ORA-09758: osnipn: could not check port in name server.

1 Answers  


ORA-00475: TRWR process terminated with error

1 Answers  


SQL*Loader-00608: subpartition not empty for INSERT option; table string, subpartition string

1 Answers  


ORA-39316: illegal clean_up() call: last clone operation is failed

1 Answers  


NNL-01009: Outbound message contexts freed: number

1 Answers  


Categories