ORA-01401 When Migrating from SQLServer to Oracle (using OMWB)

From: Krist <xtanto_at_hotmail.com>
Date: 8 Jul 2004 21:07:44 -0700
Message-ID: <cb48a3b.0407082007.6d63852c@posting.google.com>

Hi All,

I am migrating SQLServer2000 on Win2003 server into Oracle 9i on AIX using OMWB. The NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1 Many tables are just fine but there are 6 tables where I found these problem / error . 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, here are the cases I found :

• when I try to transfer non-english characters such as " é " => Error ORA-01401. It is in Char(8) Column 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 VARCHAR2(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)

This is a problem for user for modifying column width , this could affect their front end. how can I solve this problem ? What are the possibilities ?

Thank you for your help,
Krist Received on Thu Jul 08 2004 - 23:07:44 CDT