Problem:
Imp-00019: Row reject due to Oracle error 12899
Imp-00003: encountered Oracle error 12899
ORA-12899: column "jackeyj". "jk_register". "opname" is too large (actual value: 21, maximum value: 20)
Column 1 523
This error occurs when the IMP to the 10g Database is obtained from the exp data in the 9i environment.
Solution:
Modify the character set of Oracle 10 GB
Oracle
Modify the database character set to zhs16gbk.
View server Character Set SQL> select * from V $ nls_parameters
Modify: $ sqlplus/nolog
SQL> Conn/As sysdba
If the database server has been started, run the shutdown immediate command to shut down the database server,
Run the following command:
SQL> shutdown immediate
SQL> startup Mount
SQL> alter system enable restricted session
SQL> alter system set job_queue_processes = 0
SQL> alter system set aq_tm_processes = 0
SQL> alter database open
SQL> alter database character set zhs16gbk
Error at line 1: ORA-12721: operation cannot execute when other sessions are active
If the preceding error occurs, use the following method to modify it. Use internal_use to skip the superset check:
SQL> alter database character set internal_use zhs16gbk
SQL> shutdown immediate
SQL> startup