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