If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Hi, we are having some problems updating columns in a table with bitmap indexes. The table is a de-normalized DW dimension with more than 6 million rows and 140 columns. It is updated every night and we are currently dropping all the bitmap indexes on it before updating the column values with the most recent data from the OLTP system. The real problem is if the indexes are not dropped they grow very huge that they eat-up all the free-space in the tablespace and finally hit "Next Extent" error.
Have anybody faced a similar problem and found a solution to update the table without dropping the BITMAP indexes??
Any advise will be appreciated. Thanx.