File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
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...
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: how to delete data from huge table.