Re: Problems with Index in Oracle 7.2

In article <32551D01.467A_at_compuserve.com>, <75663,327_at_compuserve.com> writes:
> Path: news.ou.edu!news.nodak.edu!netnews1.nwnet.net!netnews.nwnet.net!news.sprintlink.net!news-chi-13.sprintlink.net!demos!news.stealth.net!www.nntp.primenet.com!nntp.primenet.com!howland.erols.net!EU.net!usenet2.news.uk.psi.net!uknet!usenet1.news.uk.psi.net!uknet!psinntp!psinntp!pubxfer.news.psi.net!usenet
> From: Kevin Loney <"75663,327"_at_compuserve.com>
> Newsgroups: comp.databases.oracle
> Subject: Re: Problems with Index in Oracle 7.2
> Date: Fri, 04 Oct 1996 10:19:45 -0400
> Organization: Astra Merck Inc.
> Lines: 20
> Message-ID: <32551D01.467A_at_compuserve.com>
> References: <531cja$h4m_at_kocrsv08.delcoelect.com>
> NNTP-Posting-Host: gatekeeper.astramerck.com
> Mime-Version: 1.0
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
> X-Mailer: Mozilla 2.02 (Win95; I)
> To: "awdorrin_at_ictest.delcoelect.com"@INTERNET
>
> 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
>

Kevin is refering to the "HIGH WATER MARK" located in the table header block, I think thats the right terminology. Deleteing records does not lower this parameter. You must truncate the table to reclaim the tables space before building you index. I guess I would do an export first Ha Ha.

Martin Douglas Received on Fri Oct 04 1996 - 00:00:00 CEST