loading text into Oracle

From: Binh Do <binhdo_at_onramp.net>
Date: 1998/02/15
Message-ID: <6c7drb$sq$1@news.onramp.net>#1/1

I am trying to load a commad delimited file into an oracle table. I tried using SQLLOADER but some of my data columns have long text with carriage returns in them.

e.g.

var1, var2, some long text with carriage returns in them like
this third data value, var4, var5
var1, var2, another long text column
with carriage returns, var4, var5

As in the above example, I have 2 rows of 5 columns of data but the 3rd column has text with carriage returns. How do people usually load in this type of data. (Also, the data file was produced using bcp on Sybase 4.9.)

Oracle tech support suggested using the "VAR" option in my control file but that doesn't seem to work for this situation.

Any help is greatly appreciated. Received on Sun Feb 15 1998 - 00:00:00 CST