aspose 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: 466
    
    1

I would suggest that you delete your records in chunks and do frequent commits...
 
Consider Paul's rocket mass heater.
 
subject: how to delete data from huge table.