Re: mass deletes

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Mon, 9 May 2005 13:01:04 +0200
Message-ID: <427f42ef$0$24166$ba620e4c@news.skynet.be>

"chao_ping" <zhuchao_at_gmail.com> wrote in message news:1115635714.131114.294430_at_o13g2000cwo.googlegroups.com...
> In some database tables are not partitioned, users often do:
> insert into table_hist select * from table where end_date > sysdate
> -360;
> delete from table where end_date > sysdate -360;
>
> Isn't it some kind of archive history data?:)
>

Correct, but that's not what the OP wants to do. He only talks about a mass delete on some tables, there's no archiving involved. Received on Mon May 09 2005 - 06:01:04 CDT