|
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
|