Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Long column too large during import
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