Imp-00019:row rejected due to ORACLE error 12899

IMP-00019: Row rejected Due toORACLE Error12899IMP-00003: ORACLE Error12899Encounteredora-12899: Value too large for column"CRM". bk_ecs_order_info_00413 "." POSTSCRIPT "(Actual:895, Maximum:765) Import Log Report imp-00019: Due to ORACLE error12899and Reject line imp-00003: ORACLE Error encountered12899ORA-12899: Column "Jackeyj". " Jk_register "." Opname "value is too large (actual value: +, Maximum value: -This problem occurs because the character set of the production library and the character set of the native test library are different. to the production library.SelectUserenv'language') fromdual; View to is ZHS16GBK, and native hangar is UTF-8 Use the command to modify the native library character set SQL>SHUTDOWNImmediatesql>STARTUP Mountsql>ALTERSYSTEM ENABLE RESTRICTED SESSION; SQL>ALTERSYSTEMSETJob_queue_processes=0; SQL>ALTERSYSTEMSETAq_tm_processes=0; SQL>ALTER DATABASE OPENSQL>ALTER DATABASE CHARACTER SETInternal_use ZHS16GBK; SQL>SHUTDOWNImmediatesql>startup settings after import success! Also note that the table space and the user should be built and production library table space name, data file name, user name, password are consistent ;

When I imported Oracle, I found that several tables had been imported with an error: Error message: IMP-00003: ORACLE Error959Encountered ORA-00959: tablespace'HB'Does notexist reason: To import a library if there is a table field type of CLOB, and the name of the tablespace to be imported is different from the original table space name, the error is reported. Workaround:1. Pre-built table space required for CLOB field in target2. Build the Dept table structure on the target side in advance and use the parameter content when importing IMPDP.=data_only (I didn't use it)3. When importing using IMPDP, use the parameter remap_tablespace=youfee_lob:users remap_tablespace Database object originally exists in a table space, now you don't want to put it there, want to change to B, use this remap_tablespace=A:b

Transferred from: http://www.blogjava.net/cpegtop/articles/371962.html

Http://www.cnblogs.com/xbding/p/3402346.html

(EXT) Imp-00019:row rejected due to ORACLE error 12899