sql*loader and long
Date: 1996/09/02
Message-ID: <322B6004.4F45_at_openmarket.com>#1/1
I have a table that has one column declared to be long.
SunOS 5.5.1 sparc SUNW, Ultra-2
Oracle 7.3.2
I cannot use Reclen since it is obsolete and has no effect.
I've tried specifying "RECSIZE ##" in the control
file, but I get SQL*Loader-500 Unable to open file (/blah)
when using this.
I've tried specifying char(3000) after the column name in the
control file, but this does not work either.
I've tried various delimiters, and even positional data. The newlines must be preserved in the data.
Unfortunately, I have not come across the correct combination.
What has been successful for you?
Thanks in advance,
Debi Jorge jorge_at_openmarket.com
Open Market, Inc. http://www.openmarket.com/
245 First Street
Cambridge, MA 02142 (617) 252-3484 Fax: (617) 621-1703
Received on Mon Sep 02 1996 - 00:00:00 CEST