Welcome Guest ( Log In | Register )


 
 Reply to this topicNew Topic
Procedures for how to prune data in Sentinel Oracle Database
Gary Tennessen
post Oct 1 2009, 12:47 AM
Post #1


Visitor
*

Group: Members
Posts: 2
Joined: 18-November 08
From: Walnut Creek, CA
Member No.: 190
In the past, I have used the below commands to purge Sentinel data. Now I am looking to schedule a prune cycle where I delete rows older than yyyymmdd. I would like to run this weekly or monthly and remove data older than say two years.

Or would it be better to develop a Sentinel Request and remove rows using the SQL delete statement?


./trkcmd purge -tabname "TrkTable(XFBLog,current)"
./trkcmd purge -tabname "TrkTable(XFBLog,historic)"

./trkcmd purge -tabname "TrkTable(XIBTRANSFER,current)"
./trkcmd purge -tabname "TrkTable(XIBTRANSFER,historic)"

./trkcmd purge -tabname "TrkTable(XIBMESSAGE,current)"
./trkcmd purge -tabname "TrkTable(XIBMESSAGE,historic)"

./trkcmd purge -tabname "TrkTable(XFBTRANSFER,current)"
./trkcmd purge -tabname "TrkTable(XFBTRANSFER,historic)"

./trkcmd purge -tabname "TrkTable(XFBMESSAGE,current)"
./trkcmd purge -tabname "TrkTable(XFBMESSAGE,historic)"
Go to the top of the page
 
+Quote Post
Stench
post Nov 26 2009, 12:33 PM
Post #2


Visitor
*

Group: Members
Posts: 2
Joined: 11-November 09
From: European Penisula of Asia (TZ=CET)
Member No.: 838
i would use a rule.
Go to the top of the page
 
+Quote Post
 

Reply to this topicNew Topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Powered By IP.Board 2.3.6 © 2010  IPS, Inc.
Skin designed by IPB Forum Skins