how to redefine the column size but not to reacreate the table?

[mokesql]

hi!
i would like to redefine the size of a column but dont want to recreate the table because there are allready data in it. the column is now defined as a varchar2(100) and i want to change it to varchar2(500). thnx for the help

 

[rcurva]

Try this:

ALTER TABLE table1
MODIFY (column1 VARCHAR2(500));

I don't think you will have a problem with increasing the size even if data already exist, the only problem is when you decided to decrease the size and there are data in it.