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: mass deletes

Re: mass deletes

From: chao_ping <zhuchao_at_gmail.com>
Date: 9 May 2005 03:48:34 -0700
Message-ID: <1115635714.131114.294430@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?:) Received on Mon May 09 2005 - 05:48:34 CDT

Original text of this message

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