Re: Problems with SQL*Loader

Hi Folks (Especially Suresh who tried to help me out on this.)

    I found the solution to the problem that I was having loading data. Suresh was correct in that the data should work without specific data specification. The problem was in how I specified the delimiters, specifically, my control file included:

->> FIELDS TERMINATED BY " " OPTIONALLY ENCLOSED BY '"'       (exp_1, dept_code, chgdept, exp_4 DECIMAL (9,4))

After RTFM a bit more. I found that this could be replaced with:  FIELDS TERMINATED BY WHITESPACE OPTIONALLY ENCLOSED BY '"' And everything works fine. Apparently by specifiying the blank as I did, SQL*LOADER decided that everything was a CHAR field?? I am not quite sure, but this works.

Mohammed:

    I read about your problem and while looking through the manuals for an answer to mine, did find a section regarding using SQL*LOADER to load data that takes up more than one line. There was a variable called "PIECES" that apparently did need to be set. There were several restricions on the feature such as it could only be used for one field that was split across lines/records per load. I'd look for more info on that direction. Good Luck!

Kathy Graham

mohammed_ahmed_at_my-dejanews.com wrote:

> : I'm trying to export data into oracle in text delimited format into long
> fields via SQL*Loader. The text contains carriage returns and tab (for
> things: like new paragraphs and such) but SQL*Loader is taking one line in a
> file as one record most of the records does not end in a single line it wraps
> up to the next line due to the long field column. I am getting two errors one
> is "Field in data exceeds maximum specified length" which is related to this
> long field column and the other error is "Inserted value too large for
> column" but it is not specifying the column to which this error is related. :
> Does anyone know how to make SQL*Loader recognize carriage returns?
>
> : This is crucial to our project and I would appreciate any help.
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Mon Aug 03 1998 - 19:41:14 CEST