Re: Truncate and Indexes

From: Martin Haltmayer <Martin_Haltmayer_at_KirchGruppe.de>
Date: 1998/02/02
Message-ID: <34D54471.E6620957@KirchGruppe.de>#1/1

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_at_isrv.com>
> >Date: 1/27/98 11:16PM GMT
> >Message-id: <34CE6ACE.A33551E_at_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_at_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
>
Received on Mon Feb 02 1998 - 00:00:00 CST