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