| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Bitmap Indexes
Kirti,
That error/ORA-600 occurs only on rebuild. Creation don't have this
issue...ver 7.3.4.4
Regards
Rafiq
Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Date: Fri, 08 Feb 2002 11:39:16 -0800
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,
-----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: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Date: Fri, 08 Feb 2002 05:58:21 -0800
MOHAMMAD RAFIQ
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: kirti.deshpande_at_verizon.com 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: ListGuru_at_fatcity.com (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). 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: Mohammad Rafiq INET: rafiq9857_at_hotmail.com 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: ListGuru_at_fatcity.com (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).Received on Fri Feb 08 2002 - 14:24:58 CST
 |
 |