Re: no logging database - long transaction aborted

Posted in 1998

Bill Ennis — Tue, 04 Aug 1998 9:31:30 CDT — source: Informix-list mailing list archive (1991-1998)

HI, DDL is always logged. Just in case, DDL is SQL that creates objects in the database; such as indexes. Looks like you'll need to add log space to complete the create index command. You can always drop the logs later, after you have done a backup. Bill > > I am trying to build an index on a very large table (> 1,000,000 records). > The database is in "no logging" mode and the table is locked in exclusive > mode. I am getting an error: 458: Long transaction aborted. > > Does anyone know what else could be causing the abort? > > Thanks, > > Lauren > > -----== Posted via Deja News, The Leader in Internet Discussion ==----- > http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum