Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> 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 worseReceived on Tue Jul 18 2000 - 00:00:00 CDT
![]() |
![]() |