DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Updating Bitmap Indexd Columns

  1. #1
    Join Date
    Feb 2002
    Posts
    1

    Question

    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.

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    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