Re: Loading ASCII data

> > > : No way it will be taking 6 locks. You're probably getting both a long > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > : transaction and lock exhaustion at the same time. > > > Unless, of course your rows are about 12K wide! (he says, following up on > his own post***) > If as others have posted, # locks = rows * indexes (pardon my spelling, I'm not Latin), then I'm getting six locks with relatively short rows. Thanx for all the help. -- Dan Madvig e-mail: d-madvig@bethel.edu Bethel College & Seminary phone: (612) 638-6414 3900 Bethel Drive fax: (612) 638-6001 St. Paul, MN 55112 " , ." - Marcel Marceau