Rafiq, We still have the same issues in 8.1.7.0. I have to yet applied the 8.1.7.2 patch set (may move to 9.0.2 instead). However, the growth is not as much. But it is still not acceptable. We did not set the degree of parallelism on the said table, so we did not have any ORA errors.
Regards, - Kirti -----Original Message----- Sent: Friday, February 08, 2002 10:34 AM To: Multiple recipients of list ORACLE-L Kirti, '> The only issue we had with bitmap indexes was the way it used up extents, if those were not droppped before the dataloads.' If I remember correctly, this issue was fixed in 7.3.4.4 as I was having the same problem while dataload in our datawarehouse and workaround was to drop index before inserts and an index size 10M was using unlimited space. This problem was in 7.3.4.0...Besides there were couple of other issues relating to bitmap indexes specially rebuilding of bitmap index on a table which was having degree > 1 was resulting in ORA-600 messages even if you were not specifying parallel option. I worked with Oracle Support on this issue for around one year but not resloved till I left that company..... Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Fri, 08 Feb 2002 05:58:21 -0800 MOHAMMAD RAFIQ _________________________________________________________________ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
