Home » RDBMS Server » Server Utilities » IMP-00019 error while importing (oracle; 11g; aix61)
IMP-00019 error while importing [message #414129] Mon, 20 July 2009 08:01 Go to next message
chandu_imax
Messages: 46
Registered: May 2008
Location: Hyderabad
Member
Hi,

We are having 2 database.

one is of 10g and another is of 11g.

I took the backup of one schema in 10g and am trying to import into the 11g schema.
At this time am facing the below error. Please suggest as soon as possible.

. . importing table "ACCOUNTING_AREA_SERVICE_GROUP" 21 rows imported
. . importing table "ACCOUNTING_AREA_TAX" 52 rows imported
.
.
.
IMP-00019: row rejected due to ORACLE error 12899
IMP-00003: ORACLE error 12899 encountered
ORA-12899: value too large for column "C60082"."RATE_CODE"."RAUTH02" (actual: 5, maximum: 3)


Thanxs in advance.
Chandu

Report message to a moderator

Re: IMP-00019 error while importing [message #414132 is a reply to message #414129] Mon, 20 July 2009 08:08 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

>>ORA-12899: value too large for column "C60082"."RATE_CODE"."RAUTH02" (actual: 5, maximum: 3)

I belive your doing export/import from different database & different character set.

If different charactere set; Then before import you may need to run CSSCAN utility.

Thanks

Report message to a moderator

Re: IMP-00019 error while importing [message #421139 is a reply to message #414129] Fri, 04 September 2009 09:21 Go to previous message
chandu_imax
Messages: 46
Registered: May 2008
Location: Hyderabad
Member
Thank you very much....

you are obviously correct. I have changed the characteristic and tried the same. Its working fine now.

Report message to a moderator

Previous Topic: Using user-defined stored functions in SQL*Loader DIRECT path
Next Topic: Datapump log file read permission
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 19:49:25 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.