Oracle DBA, How To, Error, Cause and Action

ORA-03223: Bitmap index block addressable limitation reached

ORA-03223: Bitmap index block addressable limitation reached


Cause:


The limitation of addressability of BMIB (Bitmap Index Block) was reached for the current blocksize.



Action:


If the segment size has grown greater than addressability of BMIB (Bitmap Index Block), do the following: (1) Partition the table. (2) Move the segment to a tablespace having bigger blocksize.

No comments:

Post a Comment

Thanks for your comment.