Purge scripts for statserver tables

Voice & Telephony
1

Can some help me with the oracle purge scripts for the statservers tables Login,QueueInfo,Voice Extension and status .Iam looking to purge the data which is older than 15days.

tnks…rn

2

Can any please help me out on this ???

cheers…rn

3

Hi,

What version of Oracle database you have?

R.

1 Like
4

The oracle version is 10G release 2.

thanks,

5

Hi RN,

Here are the SQL scripts for purging StatServer’s tables. You can delete records older then specified date using these scripts. Just replace the date ‘2008-07-01’ (July 1st 2008) in the commands below with different date.

Please test these scripts carefully before using them on production system!

R.

— purge table “LOGIN” by date
DELETE LOGIN
WHERE TIME < ((TO_DATE(‘2008-07-01’,‘YYYY-MM-DD’)-TO_DATE(‘1970-01-01 00:01:00’,‘YYYY-MM-DD HH24:MI:SS’))360024);

— purge table “QINFO” by date
DELETE QINFO
WHERE StartTime < ((TO_DATE(‘2008-07-01’,‘YYYY-MM-DD’)-TO_DATE(‘1970-01-01 00:01:00’,‘YYYY-MM-DD HH24:MI:SS’))360024);

— purge table “STATUS” by date
DELETE STATUS
WHERE StartTime < ((TO_DATE(‘2008-07-01’,‘YYYY-MM-DD’)-TO_DATE(‘1970-01-01 00:01:00’,‘YYYY-MM-DD HH24:MI:SS’))360024);

— purge table “VOICE_REASONS” by date
DELETE VOICE_REASONS
WHERE START_TIME < ((TO_DATE(‘2008-07-01’,‘YYYY-MM-DD’)-TO_DATE(‘1970-01-01 00:01:00’,‘YYYY-MM-DD HH24:MI:SS’))360024);

1 Like