Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Loading long columns from tsv-files?
Hi!
I have a problem loading (using SQL*Loader 8.0.5.0.0)
data from a tabsepareted file.
One of the columns have rather long values (5-600 characters and more)
I get errormessages when the column have more than 255 characters. The recieving column is a VARCHAR2(2000).
I have recently read somewhere in the documentation that the default
maximum
length of a column loaded in this manner is 255 characters.
I tried to find something in the doc's about adjusting this length,
or on how to solve the problem.
There must be a simple solution, or??
Regards
Göran K
![]() |
![]() |