Home » RDBMS Server » Server Utilities » Error while importing
Error while importing [message #408222] Mon, 15 June 2009 06:31 Go to next message
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,
Re: Error while importing [message #408228 is a reply to message #408222] Mon, 15 June 2009 07:00 Go to previous messageGo to next message
Littlefoot
Messages: 20891
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.
Re: Error while importing [message #408262 is a reply to message #408222] Mon, 15 June 2009 09:12 Go to previous messageGo to next message
BlackSwan
Messages: 25036
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?
Re: Error while importing [message #408293 is a reply to message #408262] Mon, 15 June 2009 11:20 Go to previous message
babuknb
Messages: 1734
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
Previous Topic: oracle_datapump error (merged)
Next Topic: IMP-00098: INTERNAL ERROR
Goto Forum:
  


Current Time: Sun Dec 04 10:55:33 CST 2016

Total time taken to generate the page: 0.10128 seconds