PL/SQL (MOSC)

MOSC Banner

Using Extract Command to purge datas from a table

edited Oct 10, 2009 8:23AM in PL/SQL (MOSC) 3 commentsAnswered ✓
Hi

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center