Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Long column too large during import

Long column too large during import

From: zeb <spam_at_nowhere.com>
Date: Sat, 22 May 2004 09:38:05 +0200
Message-ID: <40af021a$0$21567$626a14ce@news.free.fr>


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. Received on Sat May 22 2004 - 02:38:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US