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-03235: max # extents (string) reached in table string.string subpartition string

1 Answers  


ORA-31085: schema "string" already registered

1 Answers  


ORA-19724: snapshot too old: snapshot time is before file string plug-in time

1 Answers  


ORA-37074: (XSMCSESS02) Variable workspace object has no default aggmap.

1 Answers  


ORA-07251: spcre: semget error, could not allocate any semaphores.

1 Answers  






ORA-06711: TLI Driver: error on bind

1 Answers  


DRG-11126: context index is empty

1 Answers  


SQL*Loader-00107: Invalid maximum number of discards

1 Answers  


NZE-28813: invalid record type

1 Answers  


LSX-00144: attribute "~1S" invalid derivation-restriction value "~2S"

1 Answers  


ORA-29386: plan or consumer group string is mandatory and cannot be deleted or modified

1 Answers  


ORA-33219: (CINSERT05) %K cannot be added to workspace object because it is already a value of the dependent UNIQUE concat dimension workspace object, from leaf dimension workspace object.

1 Answers  


Categories