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 -> Loading long columns from tsv-files?

Loading long columns from tsv-files?

From: Göran K <goranNOgoSPAM_at_champion.se.invalid>
Date: 2000/03/18
Message-ID: <2899b5f0.68130d19@usw-ex0106-048.remarq.com>#1/1

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

Received on Sat Mar 18 2000 - 00:00:00 CST

Original text of this message

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