Re: Problems with Index in Oracle 7.2

>
> I had an index fail to allocate an additional extent in
>a tablespace (ran out of room.)
> I thought if I deleted information out of the table which
>the index is on, that I would free space up in the index, however
>this does not seem to be the case.
>
Even if you deleted all your rows, the index does not get smaller. You would have to rebuild the index. There may not be a problem. Check your values for NEXT_EXTENT in the USER_SEGMENTS table where segment_name={your index}. You have to alter your NEXT value to something smaller than what you largest available contiguous bytes value is in DBA_FREE_SPACE where tablespace_name= {tablespace where idex resides}. My bet is that it is highly fragmented, or you are running out of space in that tablespace.

-- 
=========================================================
            http://www.li.net/~gsa/index.html
This is my signature file, not part of this mail message.