File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes BEA/Weblogic and the fly likes Automated process to truncate a table Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Products » BEA/Weblogic
Reply locked New topic

Automated process to truncate a table

Praveen RajKumar

Joined: Aug 23, 2012
Posts: 6

We have a table where we keep track of recent transactions.
Whenever the no.of records count reaches 10000 we truncate the table.

Till now we are doing this process manually.
Is there any automated process to write a procedure and schedule it to complete this activity.

Jaikiran Pai

Joined: Jul 20, 2005
Posts: 10441

Please do not create multiple topics for the same question. Please continue discussion in your other thread here

[My Blog] [JavaRanch Journal]
I agree. Here's the link:
subject: Automated process to truncate a table
It's not a secret anymore!