1. Use an editor to open the file with the .sql extension, which contains information for the entire database.
2. Find the section of the file that describes the table.
3. Assign the column a larger value to accommodate the data.
4. 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.
