Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

IMP issue - WE8MSWIN1252 to AL32UTF8

534909Aug 23 2007 — edited Aug 23 2007
Hi 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!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 20 2007
Added on Aug 23 2007
3 comments
1,376 views