Hi John,

I have started migrating data from SQLServer2000 on Win2003 server into
Oracle 9i on AIX .
NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1
Many tables are just fine but there are 6 tables where I found these
problem/error them.
The error are the same:
ORA-01401 -> inserted value too large for column..

Here are what I found : the column width has to be made bigger on
Oracle, otherwise I get ORA-01401

- when I try to transfer non-english characters such as
" é " => Error ORA-01401.
Char(8) in SQLServer has to be transferred to CHAR(20) in Oracle 9i
(AIX)

- on other Tables :
VarChar(25) in SQLServer has to be transferred to NVARCHAR2(26) in
Oracle 9i (AIX)
CHAR(50) in SQLServer has to be transferred to CHAR(100) in Oracle 9i
(AIX)
CHAR(40) in SQLServer has to be transferred to CHAR(43) in Oracle 9i
(AIX)

Of course, the user will NOT tolerate this column width modification,
how can I solve this problem ?

Thank you for your help,
Krist



*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!