Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Ater table X Truncate partition ...

Re: Ater table X Truncate partition ...

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: 2000/06/06
Message-ID: <960305529.21516.0.nnrp-09.9e984b29@news.demon.co.uk>#1/1

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_at_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.
>
>
Received on Tue Jun 06 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US