Re2: Database restructuring

} From: davidn@geis.geis.com } > Turn off logging for the database, lock the table(s) and pick any way } > you want to unload/move the data. } } > -- } > @ David Tomlinson @ } > @ dtomlnsn@netcom.com @ } } } In using tbload, you cannot lock any tables as tbload requires that the } table you are trying to load does not exists. We do turn off logging on } the database, but tbload still locks Blobpages, as well as row-level } locking on the table that it is creating. Well, I can't say about blob pages, but if tbload is locking rows during the load, then I've never encountered it. We've tbloaded/tbunloaded tables with >7 million rows without any real problems. We do turn off logging, but I can't see why tbload would do a row lock (or any lock for that matter) because it does lock the table and shouldn't need any other locks. Will (villy@collinscomp.com)