DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Sunday, January 15, 2017

ORA-12899: value too large for column DATA1 (actual: 35, maximum: 70)

Details:

1. Used expdp and created a dump for the table: SCHEMA. OBJECT_NAME

2. While doing a impdp on the target database :

ORA-02374: conversion error loading table "SCHEMA"."OBJECT_NAME"
ORA-12899: value too large for column DATA1 (actual: 35, maximum: 70)
ORA-02372: data for row: DATA1 : 0X'45737061C3B16F6C1111111111111111111111111111111111'

Solution:

When you describe the table, you will see that the column DATA1 is char(35):

SQL> desc SCHEMA.OBJECT_NAME
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 DATA_IDX                                 NOT NULL NUMBER(5)
 DATA_COLUMN                                     NUMBER(5)
 DATA_VALUE                                      NUMBER(5)
 DATA1                                         CHAR(35)

Execute the below to modify the column of the table:

SQL> alter table SCHEMA.OBJECT_NAME modify DATA1 CHAR(70);
Table altered.

Now perform the import using the below command:

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

No comments: