Kbase P19422: Warning message is generated within the schema holder log file when migrating a progress database to
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/04/2009 |
|
Status: Verified
SYMPTOM(s):
Warning message is generated within the schema holder log file when migrating a progress database to ORACLE
WARNING: TABLE <tablename> will not be created.
Table has <num> long columns.
FACT(s) (Environment):
No tables created within schema holder
Warning message are generated within the schema holder log file when running protoOra
The .sql file created during the protoORA process has the CREATE TABLE commented out
Progress table has multiple fields with RAW data type
All Supported Operating Systems
OpenEdge 10.x
Oracle DataServer
Oracle
CAUSE:
This is an expected warning message. A field that has a RAW data type in Progress is converted to a LONG RAW in Oracle. There is an ORACLE limitation that allows only one LONG column per table.
This limitation is clearly documentated on the ORACLE documentation, and also is documented within the Progress DataServer for ORACLE Guide ( under Pogramming Considerations; Data Types)
**ORACLE allows only one LONG column per table.**
FIX:
Before running the migration, only allow one field/per table in Progress to have RAW data type