IMP issue - WE8MSWIN1252 to AL32UTF8
534909Aug 23 2007 — edited Aug 23 2007Hi all,
I am experiencing a problem importing a dump that received from an external client. The client is possibly using WE8MSWIN1252 it seems from log I have generated using the show=y parameter. Heres, the snip from the log
Export file created by EXPORT:V09.02.00 via conventional path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
import server uses AL32UTF8 character set (possible charset conversion)
. importing ******'s objects into ******
My server uses AL32UTF8.
The nls_lang parameter in the registry is set to American_America.AL32UTF8.
Length semantics set to CHAR.
During the import I get a lot of ORA-12899 errors.... After drilling through the logs I seem to have found out that there are 3 tables, and one column on each table that seems to be failing...
ORA-12899: value too large for column "SCHEMA"."TABLE"."COLUMN" (actual: 51, maximum: 50)
Column 1 9988562
Column 2 780918
Column 3 3
Column 4 2 'some non-english text.............................'
Column 5
I have created a log using the show=y parameter and increased the offending column lengths according. Now I am not sure if -
1. How can I do the import with the new DDL for the problematic tables?
2. Would it be good enough to just drop the offending tables, and manually run the DDL for these 3 tables?
3. If the answer to 2 is yes -how do I insert the data into these tables? As in the show=y log, it only seems to have listed a load of DDL and SPs...
Any inputs are highly appreciated.
Thanks a lot in advance!