Try OpenEdge Now
skip to main content
DataServer for Oracle
The DataServer Tutorial : OpenEdge DB-to-Oracle utility : Oracle size limitations : Column width : Changing the width of the column
 
Changing the width of the column
To change the width of the column:
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.
5. Load the data.