Re: Long column too large during import

zeb wrote:

> Hi,
>
> I try to import a table
>
> from 8.1.7.4 to 9.2.0.5
>
> I have the follwing pb during the import:
>
> Connected to: Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit
> Production
>
> With the Partitioning, OLAP and Oracle Data Mining options
>
> JServer Release 9.2.0.5.0 - Production
>
> Export file created by EXPORT:V08.01.07 via conventional path
>
> import done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set
>
> export server uses WE8ISO8859P1 NCHAR character set (possible ncharset
> conversio
>
> n)
>
> IMP-00046: using FILESIZE value from export file of 2048000000
>
> . importing DVNFR's objects into DVNFR
>
> . . importing table "DHACCMVT"
>
> IMP-00020: long column too large for column buffer size (7)
>

// *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.

Mind the last line... your buffer may be too large.

-- 

Regards,
Frank van Bortel