Re: question on logical log

>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. -------------------------------------------------------------------------- ------------------------------------- I don't think it is a good idea to increase LTXHWM and LTXEHWM. This could lead to an un-recoverable long transaction situation. I think that it would be be better to either turn off logging on the table during the load, or to increase the amount of log space on the system. The only disadvantage with turning logging off, is that you will have to turn it back on later. Check out dbload Madison Pruet