ALTER TABLE my_table MODIFY (my_col VARCHAR2(100));The biggest concern here is that when the column's value is updated, it may not have enough room in the block to expand should the PCTFREE setting be too low. This can lead to row migration, which can hamper application performance. If you feel your PCTFREE storage parameter is too low for your table, then you might want to reorganize the table.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.