How to quickly increase column size in Oracle? In our Oracle 11 database we have a table with more that 100 million rows and we would like to increase size of one column (not used in any index). I tried to execute command

alter table shipment modify (description varchar2(21) );


but it takes to much time. Is there any other (faster) way to increase column size?
Your two options are (depending on the use case):

https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:8753545300346585555

https://asktom.oracle.com/pls/asktom/asktom.search?tag=best-way-to-change-the-datatype-of-a-column-in-a-table-with-20-million