Re: Set rowcount

Yogesh Patel wrote: > David, > > So, for the online 5.0 users, what is the alternative? > > I have million rows to delete. > > Besides, everytime I try to delete somewhat large amount of rows, > I get following error message. > > -458 Long transaction aborted. > Have you considered unloading the rows you don't want to delete then dropping the table, re-building it and then loading again? Certainly, this only applies, if (no. of rows to delete)>>(no. of rows to keep) Roland