Kbase P133468: Oracle Error 910 During Progress to Oracle Migration
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/31/2008 |
|
Status: Unverified
SYMPTOM(s):
Oracle error 910 during ProToOra migration
Ora 910: specified length too long for its datatype
FACT(s) (Environment):
The error occurs during creating Oracle objects
The table that errors out has array field
The sql statement for the array field looks like following
CREATE TABLE mytable (
col1 number,
col2 varchar2 (6),
col3 varchar2 (32),
col4##1 varchar2 (-2),
col4##2 varchar2 (-2),
col4_auth##3 varchar2 (-2),
)
Selected "using sql-width" during migration
All Supported Operating Systems
OpenEdge 10.x
Oracle DataServer
Oracle
CAUSE:
Bug# OE00172253
FIX:
1. Manually modify the generated sql statement to make the length a valid value. for example
CREATE TABLE mytable (
col1 number,
col2 varchar2 (6),
col3 varchar2 (32),
col4##1 varchar2 (12),
col4##2 varchar2 (12),
col4_auth##3 varchar2 (12),
)
2. Using oracle tools to load the table definitions .sql
3. Schema pool the table into schema holder
4. Run adjust schema against these tables