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 rows rejected

user9182826Apr 10 2013 — edited Apr 10 2013

hi

i am exporting / importing from 10.2.0.4.0 to 11.2.0.3.0 but while doing import some of rows are rejected ...

IMP-00019: row rejected due to ORACLE error 12899
IMP-00003: ORACLE error 12899 encountered
ORA-12899: value too large for column XXXX (actual: 51, maximum: 50)
Column 1 264
Column 2 123432
Column 3
Column 4 7
Column 5
Column 6
Column 7 08-MAR-2007:00:00:00
Column 8 10:46:19
Column 9
Column 10
Column 11 SAMPLE DATA SAMPLE DATA SAMPLE DATA SAMPLE DATA Â£15.0...
Column 12
Column 13 Y

having looked at data in source system i cant see see character "Â" in the column 11 i think this is what causing issue !!
why is oracle adding this character to this field ?
how can i fix this ? without having to modify table in new system to allow more characters?

thank you