Re: question on logical log

On 13 Mar 1997 07:13:08 -0500, stephane.magnan@eur.autodesk.com ("Stephane Magnan") wrote: > Hi, > > This week-end, we have to load data in a database. > > I would like to know if we will meet a problem with long transaction. > > We want use the sql statment 'load from filename ....' > > Could you tell me if this command execute sometimes 'commit' or it > commit at the end of loading. > > Stephane > At the end. You could run into long xact if you are loading a large table. You might want to increase the LTXHWM and LTXEHWM values before the load, but be careful about loading too many large tables at once. Hope this helps. Chris Burton cburton@gte.net