Kbase P16596: Oracle Delta.sql and Display Format change for CHAR
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
18/10/2003 |
|
Solution ID: P16596
FACT(s) (Environment):
Oracle DataServer
SYMPTOM(s):
Made format change for CHAR field
Using Schema Migration Tools
Protoora incremental does not reflect the change
Protoora incremental ignores format change
The Delta.df generated has no modification for the CHAR field
The Delta.sql generated has no modification for the VARCHAR2(n) column
CAUSE:
This is expected behavior.
"Protoora" converts Progress Char to VARCHAR2(n) according to the Format during an initial protoora (option "Progress DB to ORACLE..") but incremental protoora ignores the format change.
FIX:
1. Make a manual change in the .df generated for adjusting the format as you want it and load it.
2. After that, you either make a manual change in the .sql generated or you use the tool ADJUST SCHEMA after having run the non modified .sql file.