Skip to Main Content

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!

ORA-02374 ORA-12899 ORA-02327 when using impdb PLZ HELP!!

user10243788Oct 26 2010 — edited Oct 26 2010
Hi All,
I am getting the following error when i am using impdp
ORA-02374: conversion error loading table "STAGING1"."REGBAS_STG"
ORA-12899: value too large for column ARAB_FAM_NAME (actual: 95, maximum: 88)
ORA-02327: data for row: ARAB_FAM_NAME : 0X'BFBFBFBFEABFEA202020202020202020202020202020202020'
The export was taken from a oracle 11 g r2 database 64 bit database and i am importing it to oracle 11g r2 database which is 32bit, could this be causing this error?

can i create the structure of the table without loading the data and then edit this particular feild and increase it, and then load the data so that it i can avoid this error.

this is quite urgent and if i can import other tables except this, that will also be good, will work on this issue after importing all the other tables,

thanks,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 23 2010
Added on Oct 26 2010
2 comments
515 views