From: Martin Haltmayer <Martin_Haltmayer@KirchGruppe.de>
Subject: Re: Truncate and Indexes
Date: 1998/02/02
Message-ID: <34D54471.E6620957@KirchGruppe.de>#1/1
Content-Transfer-Encoding: 7bit
References: <34CE6ACE.A33551E@isrv.com> <19980128103701.FAA22625@ladder03.news.aol.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Organization: KirchGruppe
Newsgroups: comp.databases.oracle.server



You may specify "drop table blabla drop storage" or "drop table blabla reuse
storage" (Oracle 7.3.3).

Martin Haltmayer

L120bj wrote:
> 
> >Subject: Truncate and Indexes
> >From: Jeff Hunter <jhunter@isrv.com>
> >Date: 1/27/98  11:16PM  GMT
> >Message-id: <34CE6ACE.A33551E@isrv.com>
> >The answer seems obvious but I want to run it past the
> >experts first. Suppose you have table A and table A has
> >an index called X. When you truncate table A does index
> >X reclaim its space.
> >
> >Thanks in Advance
> >--Jeff
> >
> >Jeffrey Hunter                     Internet: jhunter@isrv.com
> >Programmer/Analyst                 WWW: www.isrv.com/~jhunter
> >PO BOX 832                         Voice: (412) 284-7325
> >Butler, PA 16003-0832              FAX: (412) 789-9601
> >
> >
> Indeed it does
>    Rob
>