Re: How to delete hugh amount of data?

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