ORA-02374: Conversion error loading table during impdp

Error:


ORA-02374: conversion error loading table  “SCHEMA”.”TABLENAME”
ORA-12899: value too large for column ENAME (actual: 66, maximum: 64)
ORA-02372: data for row: ENAME : 0X’45737061C3B16F6C2020202020202020202020202020202020′




More About the Error:


1.        Used expdp and created a dump for the table: SCHEMA.TABLENAME
2.        While doing a impdp on the target database :
ORA-02374: conversion error loading table “SCHEMA”.”TABLENAME”
ORA-12899: value too large for column ENAME (actual: 66, maximum: 64)
ORA-02372: data for row: ENAME : 0X’45737061C3B16F6C2020202020202020202020202020202020′


Solution:


When you describe the table, you will see that the column ENAME is char(64):


SQL> desc  SCHEMA.TABLENAME
 Name                                      Null?    Type
 —————————————– ——– —————————-
 ENUM                                     NOT NULL  NUMBER(5)
 ENUM1                                    NOT NULL  NUMBER(5)
 ENUM2                                              NUMBER(5)
 ENUM3                                              NUMBER(5)
 ENAME                                              CHAR(64)

Execute the below to modify the column of the table:


SQL> alter table SCHEMA.TABLENAME modify ENAME CHAR(66);


Table altered.


Now perform the import using the below command:


impdp directory=DATA_PUMP_DIR dumpfile=ENAME.dmp logfile=ENAME.log tables=SCHEMA.TABLENAME table_exists_action=truncate

  • January 23, 2019 | 15 views
  • Comments