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)
>
> IMP-00018: partial import of previous table completed: 11042479 rows
> imported
>
> About to enable constraints...
>
> The import is done with:
>
> statistics=none ignore=y tables=DHACCMVT buffer=100000000 commit=y indexes=n
> constraints=n
>
> I tried buffer=10000000 , 20000000, 30000000, 60000000, 100000000
>
> with the same result ...
>
> (no LONG column in the table)
>
> What is the problem what I can do ??
>
> Thanks in advance
>
> Import terminated successfully with warnings.

buffer=<very big number>

hth
connor

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
ISBN: 1590592174

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com

Coming Soon! "Oracle Insight - Tales of the OakTable"

"GIVE a man a fish and he will eat for a day. But TEACH him how to fish,
and...he will sit in a boat and drink beer all day"

------------------------------------------------------------