Re: altering a large table

Quoting saccente,warren j... > > We have a large table that needs to be altered. We could either alter is by > using an sql alter or we can unload the table in the revised format, drop the > table, create the table in the revised format, and reload. We know the second > method will work, but will be a slightly more complicated procedure. Any > thoughts on the pitfalls of the first method (eg: root dbspace concerns, > shared memory concerns, logging concerns, etc.) > If the database that your table is in has logging turned on, you may run out of logs. If that happens, just turn off the logging, alter the table, and then turn on the logging. If you aren't using logging, you shouldn't have any problems. DAS -- David A. Snyder @ Snide Inc. - Folcroft, PA Current Release is db4glgen-3.6 UUCP: ..!uunet!das13!dave INTERNET: dave.snyder@snide.com