wood burning stoves 2.0*
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 Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Products » BEA/Weblogic
Reply locked New topic
Author

Automated process to truncate a table

Praveen RajKumar
Greenhorn

Joined: Aug 23, 2012
Posts: 6
Hi,

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.

thanks
Praveen
Jaikiran Pai
Marshal

Joined: Jul 20, 2005
Posts: 9927
    
158

Please do not create multiple topics for the same question. Please continue discussion in your other thread here http://www.coderanch.com/t/590578/JDBC/databases/Automated-process-truncate-table.

[My Blog] [JavaRanch Journal]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Automated process to truncate a table
 
Similar Threads
commit command
Java DB - Delete all records in a table.
how to truncate table?
Problem in updating/deleting data from MS Access Database
deleting records in smaller chunks and issuing commit?