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: Can a partial truncate be done?

Re: Can a partial truncate be done?

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Thu, 20 Jan 2005 08:48:53 +0100
Message-ID: <csnnp6$qle$1@news.BelWue.DE>


Pete's wrote:
> Alter table ..... drop partition should do the same.
>
> Pete's
>

Only if the table you wan't to delete from is already partitioned *and* the rows you want to delete happen to be precisely in one partition *and* no other rows are in that partition. None of these requirements where mentioned in the OP so I assumed he had a normal heap table without partitioning.

Cheers
Holger Received on Thu Jan 20 2005 - 01:48:53 CST

Original text of this message

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