use ALTER TABLE rather than Enterprise Manager

Your best bet for changing the size of a column in a large table is to use the ALTER TABLE command rather than Enterprise Manager. This is because when Enterprise Manager changes the size of a column, it creates a copy of the table, does an INSERT/SELECT
operation to change the column format, drops your original table, then renames the new table to the same name as the old table.

Source: SQLMag