Re: Changing column width of full table?

Billy O'Connor (billyoc_at_iii.net) wrote:

:> Can I change the width of a column in a table that's loaded with
:> 2 million records? Please?<g>

alter table emp

    modify (first_name varchar2(30)) ; /* increase to 30 char */

you can not reduce the size without:
exporting the data,
truncating the table,
droping the table,
rebuilding the table with the smaller size, importing the data.

--
This posting represents the personal opinions of the author. It is not the
official opinion or policy of the author's employer. Warranty expired when you
opened this article and I will not be responsible for its contents or use.