character set problem

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

character set problem

Arsalan
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
Reply | Threaded
Open this post in threaded view
|

Re: character set problem

ErmanArslansOracleBlog
Administrator
See this note ->

ORA-01401 / ORA-12899 / ORA-01461 While Importing Or Loading Data In An AL32UTF8 / UTF8 (Unicode) Or Other Multibyte NLS_CHARACTERSET Database. (Doc ID 1297961.1)