Hi All,
I am trying to do an full import which is failing on this table as the Ncharacterset of db is different from source(UTF8) and target is AL16UTF16,
db characterset for both is AL32UTF8,column PART_DESC"
"" NVARCHAR2(4000).Can you lease suggest something.



importing IRDSTGPRD's objects into IRDSTGPRD
IMP-00017: following statement failed with ORACLE error 910:
"CREATE TABLE "CC_STG_RAS_PRODUCT" ("PART_NO" VARCHAR2(255), "PARENT_PIN" VA"
"RCHAR2(255), "FORDATE" VARCHAR2(255), "PART_NAME" VARCHAR2(255), "PART_DESC"
"" NVARCHAR2(4000), "PH_LEVEL_CD" VARCHAR2(255), "PH_LEVEL_NO" VARCHAR2(255)"
", "PH_LEVEL_NAME" VARCHAR2(255), "GBU_CD" VARCHAR2(255), "GBU_NAME" VARCHAR"
"2(255), "GBU_DESC" VARCHAR2(255), "DIVISION_CD" VARCHAR2(255), "DIVISION_NA"
"ME" VARCHAR2(255), "DIVISION_DESC" VARCHAR2(255), "TYPE_CD" VARCHAR2(255), "
""TYPE_NAME" VARCHAR2(255), "TYPE_DESC" VARCHAR2(255), "LINE_CD" VARCHAR2(25"
"5), "LINE_NAME" VARCHAR2(255), "LINE_DESC" VARCHAR2(255), "FAMILY_CD" VARCH"
"AR2(255), "FAMILY_NAME" VARCHAR2(255), "FAMILY_DESC" VARCHAR2(255), "PRODUC"
"T_CD" VARCHAR2(255), "PRODUCT_NAME" VARCHAR2(255), "PRODUCT_DESC" VARCHAR2("
"255), "MODEL_CD" VARCHAR2(255), "MODEL_NAME" VARCHAR2(255), "MODEL_DESC" VA"
"RCHAR2(255), "PRODUCT_TYPE" VARCHAR2(255), "PRODUCT_TYPE_NAME" VARCHAR2(255"
"), "PH_PROCESSOR_TYPE" VARCHAR2(255), "PH_PROCESSOR_VAR_CD" VARCHAR2(255), "
""PH_PROCESSOR_MHZ" VARCHAR2(255), "PH_KIT_DSGN_CD" VARCHAR2(255), "PH_CNTRF"
"N_CD" VARCHAR2(255), "PH_DEMAND_REGION_CD" VARCHAR2(255), "PH_ODM_CODE" VAR"
"CHAR2(255), "PH_PRODUCT_CATEGORY_GROUP" VARCHAR2(255), "PH_MARKETING_SORT_S"
"EQ_NO" VARCHAR2(255), "PART_NUMBER_FORMAT_CODE" VARCHAR2(255), "SEGMENT_CD""
" VARCHAR2(255), "SEGMENT_NAME" VARCHAR2(255), "SEGMENT_DESC" VARCHAR2(255),"
" "COL45" VARCHAR2(255)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STOR"
"AGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "IRDSTGDATA" LO"
"GGING NOCOMPRESS"
IMP-00003: ORACLE error 910 encountered
ORA-00910: specified length too long for its datatype