Hi, We have a requirement to do a mass delete on huge tables (One of tables has ~ 400000000 rows). We need to clear out data older than a particular date. Deleting the rows at one shot does not work, the operation is rolled back.
Any pointers as to how to perform the delete in batches would be helpful. Would it be possible to delete the rows without logging? Will that allow huge mass deletes? Thanks!! Ramya ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html