DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2002


    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.


  2. #2
    Join Date
    Jun 2000
    Madrid, Spain
    cant you rebuild them?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.