| Error while importing [message #408222] |
Mon, 15 June 2009 06:31  |
Lama
Messages: 37
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  |
Littlefoot
Messages: 9167
Registered: June 2005
Location: Croatia, Europe |
Senior Member |
|
|
| 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.
|
|
|
|
|
|
] 
Members
Search
Help
Register
Login
Home
