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)
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
Recent Posts
