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.
Click Here to Expand Forum to Full Width