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

Home -> Community -> Usenet -> c.d.o.tools -> Re: How to delete hugh amount of data?

Re: How to delete hugh amount of data?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: 2000/07/18
Message-ID: <397462D2.1C7B@yahoo.com>#1/1

Carsten Jacobs wrote:
>
> Hi,
>
> I want to
> delete from mytable
> where mydate < to_date('2000-07-10 00:00:00','YYYY-MM-DD HH24:MI:SS');
>
> this is about half of the table rows (about 1,200,000).
> This takes a long time. Does anybody know a faster way to do this
> delete?
>
> Unfortunetly the truncate command has no where clause, because I'm sure
> to delete this rows and don't need a rollback.
>
> ---------------------------------------------------------------
>
> Name: carsten.jacobs.vcf
> Part 1.2 Type: text/x-vcard
> Encoding: 7bit
> Description: Visitenkarte für Carsten Jacobs

Probably quicker to create a table with the ones you want to keep (using nologging and parallel) and then use that.

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse
Received on Tue Jul 18 2000 - 00:00:00 CDT

Original text of this message

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