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 -> Re: Newbie, help again with sqlloader

Re: Newbie, help again with sqlloader

From: Alexander Romanov <sashar_at_comita.spb.ru>
Date: Mon, 5 Apr 1999 14:31:27 +0400
Message-ID: <7ea3fe$ca4$1@dragon.infopro.spb.su>


Hi All

RTFM
--- CUT HERE ----
Using POSITION with
Data that Contains
TABs

When you are determining field positions, be alert for TABs in the datafile. The following situation is highly likely when using SQL*Loader's advanced SQL string capabilities to load data from a formatted report:
 You look at a printed copy of the report, carefully measuring all of the character positions, and create your control file.  The load then fails with multiple "invalid number" and "missing field" errors.
These kinds of errors occur when the data contains TABs. When printed, each TAB expands to consume several columns on the paper. In the datafile, however, each TAB is still only one character. As a result, when SQL*Loader reads the datafile, the POSITION specifications are wrong.
To fix the problem, inspect the datafile for tabs and adjust the POSITION specifications, or else use delimited fields. The use of delimiters to specify relative positioning of fields is discussed in detail beginning on page 5 - 58. Especially note how the delimiter WHITESPACE can be used.
--- CUT HERE --- Jean-Philippe Martin пишет в сообщении
<_aUN2.536$Eb4.811_at_weber.videotron.net> ...
>How can I load a .dat file with sqlloader that has tabs for delimiting
> fields (variable length): ? I tryed whitespaces but it does not seem to
>work.
Received on Mon Apr 05 1999 - 05:31:27 CDT

Original text of this message

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