OraFAQ Forum: Server Utilities » Error while importing

Home » RDBMS Server » Server Utilities » Error while importing

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Error while importing [message #408222]

Mon, 15 June 2009 06:31

Lama
Messages: 45
Registered: February 2006

Member

Dear All,

I faced an error while doing import for a dump file , i copied for u the log file including the error :

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options

Export file created by EXPORT:V09.00.01 via conventional path
import done in AR8MSAWIN character set and AL16UTF16 NCHAR character set
import server uses AR8ISO8859P6 character set (possible charset conversion)
. importing APP's objects into APP
. . importing table "U_L_L0306091621" 0 rows imported
. . importing table "U_L_M0306091621" 1191 rows imported
. . importing table "U_L_E0306091621" 36 rows imported
. . importing table "U_L_D0306091621"
IMP-00009: abnormal end of export file
IMP-00020: long column too large for column buffer size (250)
IMP-00028: partial import of previous table rolled back: 6630 rows rolled back
Import terminated successfully with warnings.

Any Help would be appreciated,
Thans alot,

Report message to a moderator

Re: Error while importing [message #408228 is a reply to message #408222]

Mon, 15 June 2009 07:00

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Oracle

IMP-00020: long column too large for column buffer size (number)

Cause: The column buffer is too small. This usually occurs when importing LONG data.

Action: Increase the insert buffer size 10,000 bytes at a time (for example). Use this step-by-step approach because a buffer size that is too large may cause a similar problem.

Report message to a moderator

Re: Error while importing [message #408262 is a reply to message #408222]

Mon, 15 June 2009 09:12

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
>Export file created by EXPORT:V09.00.01 via conventional path

Are you purposefully using V9 exp against V10 database?

Does V10 database contain datatype not supported in V9?

Report message to a moderator

Re: Error while importing [message #408293 is a reply to message #408262]

Mon, 15 June 2009 11:20

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Good catch BlackSwan.

>>IMP-00020: long column too large for column buffer size (250)

Using 10g export dump; we can import in 9i; I'm correct?

Babu

Report message to a moderator

Previous Topic:	oracle_datapump error (merged)
Next Topic:	IMP-00098: INTERNAL ERROR

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 11 07:47:26 CST 2025