Re: SQL LOADER POSITIONS (X, X) - HOW /WHENTO USE

"Val" <vegas_girlie_at_hotmail.com> schrieb im Newsbeitrag news:7d04f924.0306270025.62bfac58_at_posting.google.com...
> hi -
>
> i am trying to load a flat file where the fields are defined as either
> char (40), char (50), and date. The oracle database is also defined
> as the flat files. When I load it I get an error of "invalid number"
> as well as "data in column is exceeding max limit" although i checked
> the input file and it does not exceed. The values are below what the
> specified length is. Would I need to use the positions syntax and how
> would that work. see below for an example:
>
> a - date
> b - char (40)
> c - char (50)
>
> would i also need to terminate by whitespace as well? I am confused as
> to when and how to use the POSITIONS syntax.

Hi Val,

if the columns in your file are delimited by a special character, use the TERMINATED BY clause, else use the POSITION(x:y) syntax.

What did you try to load the file? Please post your control file. If sqlldr complaints about exceeding well, use POSITON.

BTW: in general it is no good idea to have columns CHAR(xx). Make them VARCHAR2 if possible.

hth,
Guido Received on Fri Jun 27 2003 - 04:38:13 CDT