Database Software

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!

import to another character set

imagic1Apr 10 2012 — edited Apr 10 2012

Hi,

I have a problem with an import.
Data was exported from WE8ISO8859P1 character set and there is varchar2(xx) columns in tables.
Character length semantics was the default (byte) when tables created.
Now I have to import it to a database where character set is AL32UTF8 and I have receive errors like this:

IMP-00019: row rejected due to ORACLE error 12899
IMP-00003: ORACLE error 12899 encountered
ORA-12899: value too large for column "IACCESS6"."AUFTRAG"."AUFTRAGSNUMMER" (actual: 14, maximum: 13)

It is OK to some character become multibyte and the text larger than column size, but how can I instruct the import tool to change column definitions to varchar2(xx char)?
Or any solution to can import my data into a new database. (export was on Oracle 10g R2, import need to Oracle 11g R2)

Best Regards,
Imre