Problems with Index in Oracle 7.2
Date: 1996/10/03
Message-ID: <531cja$h4m_at_kocrsv08.delcoelect.com>#1/1
Here are the details:
Table_A has an index called Index_A
Table_A reached approximately 45 million rows and then Index_A failed to allocate the next extent.
I deleted approximately 15 million of those rows from Table_A (5 weeks worth of data) and then attempted to insert an additional week worth of data (around 3 million rows.) After two days worth of rows, the insertions died with an error saying 'failed to allocate additional extent' in the index. The volume of the data has not increased at all - so this isn't making any sense to me.
It seems as if I am not recovering the space in my index. Does anyone have any suggestions (other than dropping the index and recreating?)
Email would be prefered for responses.
Thanks in advance!
- Al
-- Al Dorrington awdorrin_at_ictest.delcoelect.com Database Admin Delco Electronics - IC CIM Unix Sysadmin Kokomo, Indiana, USA Phone: 317.451.9655Received on Thu Oct 03 1996 - 00:00:00 CEST