Problems encountered during testing: Imp-00019:row rejected due to ORACLE error 12899
Imp-00003:oracle error 12899 encountered ora-12899:value too for column
Character Set problem: Source Library 192.168.216.172 is Oracle 9.2.0.6 ZHS16BGK, Chinese characters occupy two byte target library when database is stored 192.168.51.67 is 10.2.0.2 UTF8, Chinese characters occupy three bytes when they are stored in the database because of the different character sets, some tables have not enough field lengths to present the database imp, resulting in an error ora-12899:value too large for column. Workaround: Execute on 51.67 database: Sql>shutdown IMMEDIATE sql>startup MOUNT sql>alter SYSTEM ENABLE restricted session Sql>a Lter SYSTEM SET job_queue_processes=0; Sql>alter SYSTEM SET aq_tm_processes=0; Sql>alter database OPEN sql>alter database CHARACTER set Internal_use ZHS16GBK--Setting the Internal_use directive does not check the character set superset: sql& Gt SHUTDOWN IMMEDIATE Sql>startup
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
