Use an editor to open the file with the .sql extension,
which contains information for the entire database.
Find the section of the file that describes the table.
Assign the column a larger value to accommodate the data.
Extract the section of the file that describes the table, including
the delete table syntax, and place it in another file named filename.sql.
Be sure to include any index information for the table. Re-create
the table by running SQL*Plus. Enter the following command at the
system prompt:
sqlplus userID/password < filename.sql
This command deletes the data definition for
the table and re-creates it.