Re: Cannot delete records on SE5

Posted in 1997

Douglas Wilson — 21 Sep 1997 00:55:50 GMT — source: Informix-list mailing list archive (1991-1998)

MRSW wrote: > > I have a SE5 table with about 600,000 rows of records to delete. It will > only allow me to delete about 500-700 rows at a time. Any more rows the > db will complain (121) cannot write log record. I check the free mem and > the dfspace, both looks okay. Any suggestions? > > Justin It might be better to write out the records you want to keep to a second table, drop the first table, then rename the second. Douglas Wilson