Re: "Transaction too long", but no logging

> > Hi, > > I have the following problem: > > I want to create an index on a table which contains 25.000.000 rows. > The index is of the type "varchar" with a max. length of 60 bytes. > > Because I got a "transaction too long" error, I turned logging off. > Nevertheless I got the same error again (error-no. 458). 1 - Schema changes are always logged. Add more log files. 2 - Varchars (especially 60 character long ones) make lousy indices. cheers j. ________________________________________________________________________ Jack Parker - Hewlett Packard, DMD/IS Boise, Idaho, USA jparker@boi.hp.com Currently on loan to PLD/PE ________________________________________________________________________ Outside of a dog a book is a man's best friend. Inside of a dog it's too dark to read. (Groucho Marx) ________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. ________________________________________________________________________