Kbase P5376: Migration from CHARACTER field to Oracle LONG column
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
GOAL:
Migration from CHARACTER field to Oracle LONG column
GOAL:
How do we support Oracle long field?
GOAL:
How does DataServer know that a long field instead of varchar2 should be created?
FIX:
Using the migration tool PROGRESS DB to ORACLE (ProtoOra), a CHARACTER field will be convert to a LONG column based on its format.
Since version 8.3A, and still true in 9.1D, when you are using Oracle 8, ProtoOra will only generate a LONG datatype when the field is > 4000 characters.
If you want to have a LONG datatype created even if the CHAR field is format X(2000) for example, then see Solution P61164: Migrating a Progress CHAR field to an Oracle LONG column