Change length of the column
635106Apr 30 2008 — edited May 2 2008I need to modify one column in a table which contains 30,000 rows, the column is about user comment for the website, previous it sets for varchar2(50), now it needs to be varchar2(200). Because this table already contains 30,000 rows, if I do
ALTER TABLE USER_FEEDBACK
MODIFY (USER_COMMENT VARCHAR2(200));
Will it do anything bad to the table, block, index, database performance because the length of the columns have been changed? Please help. Thank you.