Changing datatype of a databasefield

I have a field in a database that is of type varchar(15) that I want to alter to varchar(50). Is it possible towards a Oracle-db using something like:

Alter table TabelToAffect Alter FieldToAffect varchar(50) null

Or must I :

1) Copy the table into a temp-table
2) Delete the old table
3) Create the table
4) Copy the data from the temp-db to the new table

Or is it another solution ??

-Pål- Received on Fri Apr 27 2001 - 10:08:52 CDT