Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Ater table X Truncate partition ...
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>...Received on Tue Jun 06 2000 - 00:00:00 CDT
>Hi,
>
>Is there a way to use this :
>
>Alter Table X truncate partition Y drop storage;
>
>Without having to bebuild indexes after ...
>
>Regards.
>
>