Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

While import getting ORA-01438: value larger than specified precision error

KunwarJul 20 2010 — edited Jul 20 2010

Hi,

I am getting these errors on few tables while running an import for selected tables into a schema. Following is one of them:
++++++++++++++++++++++++++++++++++++++++++++++++++++
. . importing table "CHARGE_DISTRIBUTE"
IMP-00058: ORACLE error 1438 encountered
ORA-01438: value larger than specified precision allowed for this column
IMP-00028: partial import of previous table rolled back: 17055 rows rolled back
. . importing partition "CM1_AGREEMENT_PARAM":"AMAXVALUE" 327559 rows imported
++++++++++++++++++++++++++++++++++++++++++++++++++++

How to find out on which column the problem is occuring?

Oracle version:10.2.0.3.0
OS :SunOs

Cheers,
Kunwar

This post has been answered by Lubiez Jean-Valentin on Jul 20 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 17 2010

Added on Jul 20 2010

#general-database-discussions

5 comments

7,363 views