ORA-28604: table too fragmented to build bitmap index
(string,string,string)



ORA-28604: table too fragmented to build bitmap index (string,string,string)..

Answer / guest

Cause: The table has one or more blocks that exceed the
maximum number of rows expected when creating a bitmap
index. This is probably due to deleted rows. The values in
the message are: (data block address, slot number found,
maximum slot allowed)

Action: Defragment the table or block(s). Use the values in
the message to determine the FIRST block affected. (There
may be others).

Please add more information about this Error

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-38710: Flashback log version string is incompatible with ORACLE version string.

1 Answers  


PLS-00212: could not obtain enough memory to compile CASE statement

1 Answers  


ORA-19701: device name exceeds maximum length of string

1 Answers  


TNS-01071: %s is set to string

1 Answers  


NID-00321: Proceeding with operation

1 Answers  






QSM-02174: the materialized view does not have a UNION ALL marker column

1 Answers  


NNO-00107: line string: ignoring stale checkpoint data

1 Answers  


PCC-00129: Option "string" must be given

1 Answers  


ORA-01569: data file too small for system dictionary tables

1 Answers  


RMAN-08130: failover to copy on device type string

1 Answers  


PROC-00102: Cluster services error

1 Answers  


ORA-12471: Specified compartment or group is not authorized for user

1 Answers  


Categories