Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: mass deletes
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
![]() |
![]() |