Using Extract Command to purge datas from a table
i have a table FORUM_HISTORY and the columns where below mentioned from this table i need to purge datas by creating a procedure and keep the datas for the last 60 days
Name Null? Type
----------------------------------------- -------- ----------------------------
SCHEMA VARCHAR2(35)
OBJECT_NM VARCHAR2(35)
TABLESPACE_NM VARCHAR2(30)
SEGMENT_SIZE_KB NUMBER
NUM_ROWS NUMBER
LEAF_BLOCKS NUMBER
DAY VARCHAR2(2)
MONTH VARCHAR2(2)
YEAR VARCHAR2(4)
HIST_DT DATE
i had created the sql command to create a procedure for this
eg:
delete from FOURM_HISTORY where hist_dt between hist_dt and sysdate-60;
its working, but can any one suggest me how to call this command using extract command