From: "Jonathan Lewis" <jonathan@jlcomp.demon.co.uk>
Subject: Re: Ater table X Truncate partition ...
Date: 2000/06/06
Message-ID: <960305529.21516.0.nnrp-09.9e984b29@news.demon.co.uk>#1/1
X-NNTP-Posting-Host: jlcomp.demon.co.uk:158.152.75.41
References: <8h405j$3oi$1@news1.skynet.be>
X-Trace: news.demon.co.uk 960305529 nnrp-09:21516 NO-IDENT jlcomp.demon.co.uk:158.152.75.41
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Newsgroups: comp.databases.oracle.server
X-Complaints-To: abuse@demon.net



Make sure that all your indexes
are local indexes

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Geoffrey Dufour wrote in message <8h405j$3oi$1@news1.skynet.be>...
>Hi,
>
>Is there a way to use this :
>
>Alter Table X truncate partition Y drop storage;
>
>Without having to bebuild indexes after ...
>
>Regards.
>
>