my dog learned polymorphism*
The moose likes Oracle/OAS and the fly likes how to delete data from huge 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 » Oracle/OAS
Bookmark "how to delete data from huge table." Watch "how to delete data from huge table." New topic
Author

how to delete data from huge table.

Nagendra Batchu
Ranch Hand

Joined: Jan 23, 2008
Posts: 32
Hi

How to delete the data from huge table, For example if table called Warehouse contains data about 9 cores, then what is the best way to delete around 4 cores of data.


Please suggest


Vinod Tiwari
Ranch Hand

Joined: Feb 06, 2008
Posts: 459
    
    1
I would suggest that you delete your records in chunks and do frequent commits...
 
jQuery in Action, 2nd edition
 
subject: how to delete data from huge table.
 
Similar Threads
Delete a row by comparing two tables without frontend screen
How about scaleability of Software Pipelines?
deleting from a file
Data Grid With JSP
how to make the column unique?