Oracle Database Discussions

Hi All,

i have to purge data from a log table , containing a date column.
have to retaing last seven days of data and delete data older than that.
as the table can containg millions of data, we want to use PARTITIONING.

i am using oracle 9i. can you suggest the best approach for this.

i am doing something like below to partition basing on week of month (1 to 5).



create table term_log (id number, desp1 varchar2(1000), upd_dt date)


do i need to have a separate column containing week of month , to do above partitioning.

Thanks in advance.


Ravi Kumar M