ORA-12899 error -- imp importing data to Oracle (modifying Character Set Problem)

IMP ORA-12899 error importing data to Oracle

View Character Set: Select * From nls_database_parameters

Large | medium | small [2009/05/26 | by askwan] error message: imp-00019: Row rejected due to Oracle error 12899
Imp-00003: Oracle error 12899 encountered
ORA-12899: value too large for column "maid". "dtlmb". "cc" (actual: 66, maximum: 50)

Initially concluded that the character set problem, Chinese in the UTF-8 accounted for 3 bytes, zhs16gbk accounted for 2 bytes, and the source DMP file character set is zhs16gbk library to come out, now you want to import to the library where the target character set is the UFT-8. Quotationsql> 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;
Alter database character set zhs16gbk
* Error at line 1:
ORA-12712: new character set must be a superset of old Character Set

The internal_use command does not check the character set superset. quotationsql> alter database character set internal_use zhs16gbk
SQL> shutdown immediate
SQL> startup

If you use imp again for import, no problem will occur. Oracle @ server $ imp jrgazx/jrgazx file =/opt/jrgazx1/jrgazx1.dmp fromuser = jrgazx tables = cwfxzb, cxqk, dqbgyyplsjb, dqtzsm, dsyp, role: release 10.2.0.1.0-production on Wed May 27 01:22:54 2009

Copyright (c) 1982,200 5, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-64bit Production
With the partitioning, OLAP and Data Mining options

Export File Created by export: v10.02.01 via conventional path
Import done in us7ascii Character Set and al16utf16 nchar Character Set
Import server uses zhs16gbk character set (possible charset conversion)
Export client uses zhs16gbk character set (possible charset conversion)
. Importing jrgazx's objects into jrgazx
. Importing jrgazx's objects into jrgazx
.. Importing table "cwfxzb" 57197 rows imported
.. Importing table "cxqk" 8471 rows imported
.. Importing table "dqbgyyplsjb" 30593 rows imported
.... Importing table "dqtzsm" 11173 rows imported
.. Importing table "dsyp" 4906 rows imported
.. Importing table "dtlmb" 390372 rows imported
Import terminated successfully without warnings.

--------- End -----------