Re: Problems with Index in Oracle 7.2

Albert W. Dorrington wrote:
>
> Hi All,
>
> 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.
>

That is not the case at all. Index entries associated with deleted rows still use space in the index.

To free the space: Truncate the table (which also truncates the index) if you want to delete all of the table's rows. In Oracle7.3, use the ALTER INDEX REBUILD command to rebuild the index on the fly and reclaim the unused space. In all versions, you can drop and recreate the index to free the space.

-Kevin Loney Received on Fri Oct 04 1996 - 00:00:00 CEST