|  | 
		Salam Arslan,
 i received dumpfile from oracle database 10.2.0.1.0
 
 which have charactor set is
 NLS_NCHAR_CHARACTERSET         AL16UTF16
 NLS_RDBMS_VERSION                 10.2.0.1.0
 
 ------------------------------------------------------------------------------------------------------
 i want to import that dumpfile into oracle   11.2.0.4.0 - 64bit Production
 the character set is below
 
 SELECT value FROM NLS_DATABASE_PARAMETERS WHERE parameter='NLS_CHARACTERSET';
 
 VALUE
 --------------------------------------------------------------------------------
 AL32UTF8
 
 while i impdp it give us error like below
 
 
 ORA-02374: conversion error loading table "SCOTT"."SAD_ITM"
 ORA-12899: value too large for column SADITM_GOODS_DESC1 (actual: 84, maximum: 44)
 
 ORA-02372: data for row: SADITM_GOODS_DESC1 : 0X'2D2DA793FBA420EC93E5A320E9EFF598FBF3EC8E2096FA20E5'
 
 
 kindly guide me
 
 Thanks
 
 |