-
IMP-00003: ORACLE error 910 encountered ORA-00910: specified length too long for its
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|