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-26031: index maintenance error, the load cannot continue

1 Answers  


NNL-00994: Responses received: number

1 Answers  


NZE-29046: Session is resumable.

1 Answers  


RMAN-20240: archived log not found in the recovery catalog

1 Answers  


SQL-02156: Invalid type for Indicator or Returned Length

1 Answers  


NZE-28787: private key encryption failure

1 Answers  


ORA-22957: NULL is an invalid input to powermultiset and COLLECT functions

1 Answers  


TNS-00026: INTCTL: TNS_ADMIN directory set, and is being used

1 Answers  


DRG-50902: unexpected character string

1 Answers  


PCC-02013: unknown escape sequence

1 Answers  


NID-00124: Mismatched dbid for datafile string, expected number, found number

1 Answers  


ORA-10920: Cannot offline tablespace belonging to default temporary tablespace group

1 Answers  


Categories