RE: Please Help : commited delete

Hi amit, Are u unloading and deleting records based on a condition or is it a case of drop and create? What I want to know is if you are deleting all the records of the table? Thanks & regards, Ganesh FMR India - IT * +91-80-56916513 "Any comments or statements made in this email are not necessarily those of FISC India Pvt. Ltd. or any of the Fidelity Investments group companies. The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you have received this in error, please contact the sender and delete the material from any computer. All e-mails sent from or to FISC India Pvt. Ltd. may be subject to our monitoring procedures" -----Original Message----- From: Jack Parker [mailto:vze2qjg5@verizon.net] Sent: Thursday, November 18, 2004 5:56 PM To: ids@iiug.org Subject: Re: Please Help : commited delete [3720] you can always truncate table - or drop / recreate. If you are not dealing with the entire contents, but still some signifcant portion of the contents, it may be faster to re-write the table. j. ----- Original Message ----- From: "AMIT DIXIT" <amdixit_x@hssworld.com> To: <ids@iiug.org> Sent: Monday, November 15, 2004 4:40 AM Subject: Please Help : commited delete [3684] > Hi, > SOMEBODY please help me with this... > I have a table which I want to unload every night at 12:00 > and after unloading the table I want to delete all those rows > which I have unloaded..... > > when i give delete to those rows i get long transaction error. > > I know that logical logs are full but dont want to go onto that > solution of increasing logs size... > SOMEBODY tell me how to unlog this activity ande how to make it > commited. > I have a standard table with constraints so cannot alter table to > RAW. > > PLEASE HELP ME AND SAVE MY LIFE > REQUEST EVERYONE TO GIVE STRAIGHT ANSWER AS I AM DUMB in informix. > > Amit. > > >