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 As a rider on this, Alter table works by effectively unloading straight into a revised table. Therefore you must have enough space in the dbspace containing the table to create the new fully loaded table, while the old one still exists. Cheers - Jim -------------------------------------------------------------------- Name: Jim Gordon Internet: jgordon@ssf-sys.DHL.COM Company: DHL Systems Inc Phone: (415) 358-5911 (Work) Address: 1700 S. Amphlett Blvd. (415) 882-9728 (Home) San Mateo, CA 94402 Fax: (415) 571-6429 --------------------------------------------------------------------