Re: Delete Data older than exactly 2 years
- From: rjamya <rjamya@xxxxxxxxx>
- To: smishra_97@xxxxxxxxx
- Date: Thu, 19 Apr 2007 22:17:08 -0400
Why can't you use that logic? And come to think of it, I'd rather run this
cleanup on the FIRST sunday of the month. So, I can do a trun() at month (to
get the first), then substract 24 months. So you will always cleanup on a
month boundary.
Month to month cleanup is always better than on a random date in the last
week. What do you think?
rjamya
On 4/19/07, Sanjay Mishra <smishra_97@xxxxxxxxx> wrote:
Hi
Can somebody suggest good method to delete all record older than 2 years
from the current date. This script will run on the last sunday of each
month. I will write the logic for Last sunday in Unix shell but need some
idea about the SQL. I can't use some 365+366 or so kind of logic. THis is
9i.
Other related posts:
