Kbase P61194: Migrating a Progress CHAR field to an Oracle LONG column
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
GOAL:
Migrating a Progress CHAR field to an Oracle LONG column
GOAL:
How to modify a VARCHAR2 to a LONG for the migration from Progress to Oracle?
FIX:
If you want to have a LONG datatype created instead of a VARCHAR2 datatype, then:
1. run migration but do not create Oracle database
2. modify the SQL script generated by migration to change the field from char to long
3. load SQL into Oracle
4. pull schema to create schema holder
5. connect to both Progress and Oracle, perform adjust schema
NB: Oracle accepts one LONG column per table only.