-
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.
Venki.
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|